Need insert rows for same amount as number in a cell ex. 20 = 20 x insert rows (w attach)

Need to insert rows for same amount as the number in a cell, ex. 20 = 20 x insert rows



We have these files that relates to shipping information for products.
Each product need to end up on a single row
Current we have the information for a batch of products.
. meaning that we know we have 20 x 1 item type.
. that info is on 1 row with a cell that shows 20.

We need to end up with 20 rows of the same information but showing 1 x item type per row.

So to be clear lets use an example:
- we have 10 rows of batch items
- each batch has 5 x 1 item type
- we want to end up with 50 rows in total
- each row with 1 item

Any suggestion