how can i fill data in blank cells after copying a pivot report?

[Antz]

I need to fill data in blank cells after copying a pivot report as values.
At present this is being done by copying individual cell values and pasting
it on the blank cells below.

 

[M Kan]

You can use Edit: Go To: Fill Blanks to paste a formula. Here's a step by
step.

http://www.kan.org/tips/excel_fill_blanks.php