Forum Discussion
SAKSHI_ROY
Aug 23, 2021Copper Contributor
How to delete blank cells from Pivot table
Hi Team, Hope you are doing well. Sorry for Taking your valuable time. But could you please help me with my Excel pivot Problem. I have a table which contain some blank cells. when i make a piv...
Riny_van_Eekelen
Aug 23, 2021Platinum Contributor
SAKSHI_ROY I dare to say you can't. You'll have to delete the items with no Data field from the source table, if you don't want to use the pivot table filter.