Pivot Table ?: How to remove blanks

[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

 

[Debra Dalgleish]

From the pivot field's dropdown list, remove the check mark from
(blank), and those items will be hidden.