Copy to Individual rows from a Sumary list

[Carlit007]

Hi all trying to do the following

I have a worksheet with a couple of items I an trying to inventory out of a report.

what I am trying to do is copy and insert a new row below each items totaling the value listed in "Colum D" which hold the total quantity
for example on row 2 the item QTY on Colum "D" is 6 I would like to have 6 total rows with this item
so that I can list serial number detail on each individual item.

the idea is so that I can add another Colum listing each individual Serial number for each item
a bonus would be to copy and paste the results unmerge in sheet2 that way I can still have the source file with summary

 

[MADEASH]

You can use =REPT formula for repeat the SKU Numbers of times as required. But this will repeat within cells which you need to copy and paste as TRANSPOSE to get row wise data.