[nilodor]

Ok, I'm pulling my hair out on this. I've generated a pivot table of equipment required for an upcoming project and I have several cells displaying (blank), which looks terrible. Now I could go through and put ="" or a space in all the cells to get rid of the (blank) but I feel like there is an option I could just toggle to do this for me.

To try explain this better (I showed a little table of what it looks like at the bottom with the primary column in bold) I have one column with the primary instrument description and another column with the secondary description when an instrument requires several separate parts. Some of the instrument have several parts, and they display fine (like the sludge sampler below), but ones that don't (weather station) display a blank. I tried going into options and toggling the for empty cells show field, but it doesn't do anything and this is driving me nuts. So I'm just hoping someone out there knows the solution to this. Thank you, thank you, thank you in advance.

Weather Station
(blank)
2" Sludge Sampler
2" x 1' Liner
End Caps
Core Catcher
Brush
Body