How to avoid blank cell in Pivot table

Help Activities
, ,
7

Hey @Raja.G

Approach 1 : You can keep the Pivot in a template Sheet , and apply a Label Filter to it.
Please refer the Screenshot below for more details :
This image shows an Excel pivot table filter menu with various filtering options and checkboxes for selecting specific items. (Captioned by AI)

A screenshot shows a pivot table in Excel with a filter applied to exclude blank column names and various categories listed in the "Row Labels" section. (Captioned by AI)
A screenshot shows a pivot table in Excel with a filter applied to exclude blank column names and various categories listed in the "Row Labels" section. (Captioned by AI)962×325 18 KB

Approach 2 : If you are generating the Pivot each time , then you can use macros to apply filters or to remove the Blanks.

Hope it helps you out!
-Vikas :slight_smile: