Quantity in cell to rows



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?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!