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

Hi GC
Looks great. How do I see the "macro" of formula use to do this?
tx

Great,
I will forward to my team and see if works.
Tx guys,

Hi

We have additional criteria for this macro:

Same as before, we need to apply items from 1 line to multiple lines
However, while doing this we must lookup 3 criteria to match for application to be valid
1. Date on single row must be same or smaller than date on rows to apply (do not subs
2. Item number must be the same on single as rows to apply
3. Qty on single row is maximum number of times it can be applied to rows
If those criteria are not met, item must not be applied to the line

Example with desired result in file attached