Stop Pivot Table Counting NULL Strings and exclude them from pivot data summary selection

Originally Posted by Monkeyfud

I guess this leads me to a deviation on my original question, can the summary data be changed to only return data relevant to the count in the pivot table and not return the blank data?

no. you would have to filter the resulting extract