How do I set it so it does not show blank? I have a dynamic range set up,
thank you both for your replies, but I get blank rows in the data
occasionally that I have to manually delete. I can't for the life of me
figure out how to get rid of blanks.

"Luke M" wrote:

Either setup your pivot table to not display "blank" as an option, or create
a dynamic range that the PivotTable can refer to.

Dynamic Range:
Goto the sheet with your data table. Under Insert - Name, Define
Give your range a memorable name (MyRange) and use a formula similar to:
=OFFSET($A$1,0,0,COUNTA($A:$A),NumberOfColumns)

Where NumberOfColumns is the count of how many columns you have in your data
field.

Click Add, then out.

Back in your PivotTable, in the dialogue where you tell it what range to
look at, tell it to look at:
YourWorkbookName.xls!MyRange

The range will now dynamically increase/decrease to match your data.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*