0

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 :(

1 Answer 1

1

You can fill in the blanks afterwards as described in this question and answer or you can get your pivot table to repeat them for you before you copy/paste.

enter image description here

1
  • Thanks Mike. Appreciate the answer - sorry I can't vote up :( May 14, 2015 at 8:20

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .