Forum Discussion
slohombre
Sep 09, 2020Brass Contributor
How to remove (blank) from pivot table layout
Good morning, all. How can I remove the "(blank)" entry showing up in the Beds column of the pivot table. If there is no data in those cells, I'd like to be empty. Any help would be greatly appreciat...
JDMID
Sep 10, 2021Copper Contributor
SergeiBaklan Okay, now how do I undo that? I can't edit the cell and delete the space, and it hasn't modified my source data in any way.
SergeiBaklan
Sep 10, 2021MVP
You can't remove value here, but you may type <blank> instead of space.
- HarjithFeb 21, 2025Copper Contributor
Thank you. That was of great help !!!