Many times we need to compile data using pivot table. However when you copy data from a pivot table we find blank cells below a row label and it is big challenge to fill all those blanks with row lables. There is very simple way to fill all blank cells.
Step 1 - Select the entire range you need to fill
Step - 2Edit > Goto > Special > Blanks.
Once you click OK button, excel will select the blank cells.
Step -3 Enter the cell reference of immediate above cell in active cell without changing the selection. Hold control key and press enter
See video attached.