Multiply Rows

Question

Hi community

Im looking to multiply rows within my workbook... I have a table like the below example with the sales QTY summarized against the description.

I want to break this out into 25 lines for product 1 and 15 lines for product 2 with a QTY of 1 on each line.

Is this possible ?

Many thanks !

ProductSales QTYProduct 125Product 210

atcodedog05 · Accepted Answer

Hi @caldowd1998

Here is how you can do it.

Workflow:

Hope this helps : )

TheOC · Accepted Answer

hey @caldowd1998

The Generate Rows tool will achieve this for you. Attached as a workflow showing it in action with your data.

Hope this helps!
TheOC