Hello, I have a pivot table that I have highlighted 10,000 rows of 'potential' data for. Problem is, there's only a few hundred rows of data in there right now, and in the Pivot table at the very bottom there is fields called (blank) under each column header.
Is there anyway I can get rid of that without changing the data source?
Bookmarks