Quantity in cell to rows

Nicole Haste

Hello,

I have a column named "Quantity" and the cells of that column, I have numbers (any number). Is there a formula or a function that can create new rows (specifically of the quantity) in that sheet or another sheet automatically? Is that something this is automate-able? Example: If cell A1 in Sheet 1, has a quantity of 5, is there a formula or function that I can use to create 5 new rows in Sheet 1 and/or Sheet 2?

Thanks!

Nicole

Andrée Starå

Hi @Nicole Haste

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Here's a possible workaround or workarounds

• I have an idea to use another sheet combined with copy/rows to develop a solution, but I haven't had time to explore it yet.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Nicole Haste

@Andrée Starå

Yes! Any help with a workaround would be helpful. My attempts have not been fruitful.