Inserting new rows based on cell columns, copying data to the new rows

[jgaite]

Hi everyone,

I hope someone can help me here. I have a file with multiple rows and columns.
If there's only 1 SKU purchased, line item would be as normal - Cell A2 onwards
But if for example cell A5, there's additional after column T since it has 2 SKU purchased.

I want to have a macro where when there's additional column after Column T, it will add new rows and copy the data above it. Please take note that it can be multiple SKU purchases and doesn't end with only 2 purchase per each line item.

Here's the sample data:

And the should be data:

Thank you so much in advance!

Joane

 

[OaklandJim]

Please consider using MrExcel's excellent add in called XL2BB to post the data. See here: XL2BB - Excel Range to BBCode

Maybe provide additional data to work with.

Are there headers for the additional SKUs like SKU 2 and Quantity 2? Is there a maximum number of SKUs?