Pivot Table ?: How to remove blanks

  • Thread starter Thread starter stephen_chiu
  • Start date Start date
S

stephen_chiu

I have three columns on my data spreadsheet;
some columns have info, while others do not
and are blank.

I am trying to make a Pivot Table that
transposes the columns into rows of info.
However, when I transpose them, whenever
the data spreadsheet's cell is blank,
the pivot table lists the row as "blank."

Whenever that specific row is listed as "blank,"
how can I remove that individual row completely,
and shift all rows upward, as if
that row never existed (if no info
is required for that row)?
Whenever I check off the "do not include 'blank'
row," it removes all blanks....

Any suggestions are gladly appreciated!
Steve
 
From the pivot field's dropdown list, remove the check mark from
(blank), and those items will be hidden.
 
Back
Top