How to remove (blank) from pivot table layout

%3CLINGO-SUB%20id%3D%22lingo-sub-1649029%22%20slang%3D%22en-US%22%3EHow%20to%20remove%20(blank)%20from%20pivot%20table%20layout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1649029%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%2C%20all.%20How%20can%20I%20remove%20the%20%22(blank)%22%20entry%20showing%20up%20in%20the%20Beds%20column%20of%20the%20pivot%20table.%20If%20there%20is%20no%20data%20in%20those%20cells%2C%20I'd%20like%20to%20be%20empty.%20Any%20help%20would%20be%20greatly%20appreciated.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%20(55).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217322i5C1CD245CF0F4803%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screenshot%20(55).png%22%20alt%3D%22Screenshot%20(55).png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1649029%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1649116%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20remove%20(blank)%20from%20pivot%20table%20layout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1649116%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F676026%22%20target%3D%22_blank%22%3E%40slohombre%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EStaying%20on%20cell%20with%20blank%20in%20formula%20bar%20enter%20space%20instead%20of%20it.%20Refresh.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1649299%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20remove%20(blank)%20from%20pivot%20table%20layout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1649299%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BYou%20are%20always%20a%20tremendous%20help.%20Many%20thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPaul%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

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 appreciated.Screenshot (55).png 

3 Replies

@slohombre 

Staying on cell with blank in formula bar enter space instead of it. Refresh.

@Sergei Baklan You are always a tremendous help. Many thanks!

 

Paul

 

@slohombre , you are welcome