Pivot table - filtering out rows that have blank columns

[mbuckley]

I have a pivot table that I would like to hide a row if a certain
column is blank.

For example:

Column Heading A | Column Heading B | Column Heading C
Animal | Dog | 4
Animal | | 5
Animal | Cat | 10

etc...

So I would like to be able to hide row number 2 from the table.

How complicated is this to do?

 

[mbuckley]

The other thing is that the blank column is a data column, so I cannot
uncheck the "blank" option in the column heading dropdown.