Pivot Table reports are shown in a Compact Layout format as a default and if you have two or more Items in the Row Labels (e.g.Month & Customer), then the Pivot Table report can look very clunky…
There is a cool little trick that most Excel users do not know about that adds a blank row after each item, making the Pivot Table report look more appealing. Here is how you add these blank rows..
STEP 1: Click in the Pivot Table and go to Pivot Table Tools > Design > Blank Rows
STEP 2: You will need to click on the Blank Rows button and select Insert Blank Line After Each Item
NB: For this to work you will need at least two Pivot Table Items in the Rows Labels
You then get the following Pivot Table report:
STEP 3: To get rid off the blank rows you can press the CTRL+Z shortcut or from the Blank Rows button select Remove Blank Line After Each Item