I want to remove (blank) from Piviot table.
Steps to Reproduce:
1. I have data set (5 columns) without any blank cells.
2. I create Piviot table with this data set.
3. I add more data to the data set and refresh the Piviot table.
3. (blank)appears in the piviot table.
4. As per my research, the piviot is considering the cells after the data till the end of the sheet.
HELP: Please suggest a macro on how to ignore the blank cells at the end of the data set Sheet and avoid (blank) appearing in the piviot table.
Bookmarks