Pivot tables and blank cells
 

In a few of my columns I have blank cells, when I create a pivot table it
automatically inserts a row for blank cells. I do not need to incorporate
blank cell data into my report. How do I get rid of this?

Pivot tables and blank cells
 

Beke wrote:
In a few of my columns I have blank cells, when I create a pivot table it
automatically inserts a row for blank cells. I do not need to incorporate
blank cell data into my report. How do I get rid of this?

Hi Beke,

In the drop-down button for the category that contains blanks, uncheck
(blank).