I've run a report on products sold and used a pivot table to see products by customer. I then need to upload the data back to SF and so I have used the classic pivot table layout to be able to copy and paste into a new sheet as shown below.
Whats an easy way of filling in all the gaps other than manually copying and pasting? In this case I have about 200 rows but I have some more where I'll have 20,000+
Some items in colum A end in numbers but all are unique identifiers. Column B values are unique for each value in column A
Basically the problem is - If cell in Column A is blank fill using previous non blank value above.
Link to screenshot of problem on imgur as I don't have reputation to post one :(