Pivot table is an excellent feature of MS Excel and can be used in many different ways. If you use Pivot Tables frequently you probably realised it is not very handy to copy the data out of the pivot table and then go line by line and fill all the gaps in the columns from Row Fields.

We found a way how to do this routine in less than 10seconds. Here is our tip:

1. Select all cells you need to append with data. You don’t need to skip non blank cells.
2. Press Ctrl + G. This open the Go to dialog.
3. Press Alt + S to open the Special sub dialog.
4. Press “k” to select option “blanks”.
5. Press Enter to close the dialogs. The blank cells will be selected.
6. Hit equals “=” key.
7. Press the “Up” arrow.
8. Hold down Ctrl and hit enter. There will be a formula inserted in all blank cells.
   (Hitting equals and the up arrow you tell to Excel you want the blank cell to be just like the cell above it. By holding down Ctrl and hitting enter you are placing the same formula in every selected blanks cell.)
9. Select all data and press copy and then paste as values.

Although the procedure does not seem to be very straight forward it saves a lot of time and makes your list absolutely accurate.