Hi,

Try this. Highlight A2:A50 (adjust to match you range). Now
Ctrl+GSpecialBlanks. Now press = Up arrow key Enter. This should
plug in all blanks with the value in the cell right above.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Apprentice" wrote in message
...
Pivot
Employee Quarter Sales
A 1 100
2 115
3 120
4 105
B 1 150
2 120
Format needed
Employee Quarter Sales
A 1 100
A 2 115
A 3 120
A 4 105
B 1 150
B 2 120