How to get pivot tables not to include [=row!column] in the spaces

I'm trying to make a pivot table from a large data Table that all has [=row!column] because it's gathering data from multiple different sheets but not all that has data. I put this to update the Table uptomatically, even if there is no data it shows as [0/blank]. This has been going fine so far but now when I try to make a Pivot table to find the vaule of each column, it's including the blank spaces that have [0/blank] when that isn't what i need.

Let be clear I am not trying to remove [0/blank] from the Row list, I'm trying to remove it from the Values.