Copying data down to next dirty cell, then copying that data

[slarson]

I have pivot table outputs that return a value and say 3
or 4 criteria(sumations). This goes on for 35000 rows. I
would like the value say Store # to repeat in each cell
for each store's info (GM$,GM%,Sales,Inv,etc.).

Any ideas out there?