Multiply Rows

[caldowd1998]

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 !

Product	Sales QTY
Product 1	25
Product 2	10

[atcodedog05 · Accepted solution]

Hi @caldowd1998 

Here is how you can do it.

Workflow:

Hope this helps : )

[TheOC · Accepted solution]

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

[atcodedog05]

Happy to help : ) @caldowd1998 

Cheers and have a nice day!