Excel - fill in blank cells in row area in pivot tables

From http://www.mrexcel.com/articles/fill-pivot-blank-cells.php

Trick #1. Selecting all of the blank cells in that range.

• Hit Ctrl+G, Alt+S, K and then enter. huh?
• Ctrl G brings up the GoTo dialog
• Alt+S will pick the "Special" button from the dialog box
• The Goto-Special dialog is an awesome thing that few know about. Hit "k" to pick "blanks". Hit enter or click OK and you will now have selected just all of the blank cells in the pivot table outline columns. These are all of the cells which you want to fill in.

Trick #2.

Hit the equals key. Hit the Up arrow. Hold down Ctrl and hit enter. Hitting equals and the up arrow says, "I want this cell to be just like the cell above me." Holding down Ctrl when you hit enter says, "Enter this same formula in every selected cell, which, thanks to Trick #1 is all of the blank cells which we wanted to fill in.

Trick #3.

You now need to change all of those formulas to values. Select all of the cells in A3:B999 again, not just the blanks. Hit ctrl+C to copy this range. Hit alt+e then sv (enter). to Paste Special Values these formulas.