Copy text and delete rows in a pivot table.

[Swifey]

I have failed miserably - I have created a Pivot table and would like to write a macro to copy down the point if sale code to the row below which contains the description of the sales code and then delete the sales code row without description.

Current Report

2-Digit (All)
Shop (All)
Goods (All)
Month (All)

Row 1,Sales Code
Row 2,1030907
Row 3,
Row 4,1061805

This is what i am trying to atchieve

2-Digit (All)
Shop (All)
Goods (All)
Month (All)

Row 1,Sales Code
Row 2,1030907
Row 3,1061805

Could you please help and advise if this is possible

Regards
Swifey