Well, you have
been patiently waiting for this lesson for pages and pages. How do you
hide the blank lines? Here are the steps to Filter the Blanks, at last.
Before You Begin: Select the PivotTable. The PivotTable Tools
should be available.
Try it: Filter the Blanks
Click on the Row Labels in the PivotTable.
Click on the Columns Labels, too.
You should see Filters on the Column and Row
Labels in the PivotTable.
So far so good.