Amazon download Pulling data from one cell to others

I have a sheet with 22,000 rows 6 columns of sales data from my Amazon sales each order has between 3-6 rows. When the data comes in from Amazon some of those rows wont have my sku in the sku cell. Since i use a pivot table to summarize all my sales I need a way to pull the sku from the order number that has it. I have attached a picture of my problem. I am a beginner with Excel but I'm a quick learner so please tell me what part of excel could help me.
Thanks a lot

excel snip.jpg

Hello and welcome to the forums.

The issue only appears to be affecting successive orders. You could use a helper column where the data is stored with a formula corresponding to your first row of orders:

Formula:

Please Login or Register  to view this content.

And then drag it down all 22,000 rows.

This would find the SKU above and copy it below. You could label the helper column SKU2 and refer to it in the pivot table so all of your information is present.

This could also be done with a macro:

To enter a macro hit Alt+F11

Insert -> Module

Paste in the following code

Please Login or Register  to view this content.

Close that window

Select the Cells you wish to apply this macro to

Hit Alt+F8

Run CopyAbove


I left my comments in the code lines in case you feel like reverse engineering/teaching yourself about it.

Wow that works great the only issue I am having is if one order has 4 rows with the sku only in the first it wont fill in all the blanks. How can I change the formula for those?
Thanks a lot!! You already saved me hours of work!!!
Joseph M.

I just saw the second option I have to work on that one. I am just starting to learn Macros That probably solves my other issue.
Thanks Again!
Joseph M.

that was easy!!!!! wow worked like a charm!
Thanks a ton!
joseph M

Glad I could help.

Don't forget to mark the thread as Solved so others can reference the issue in the future.