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
Check out the Formula Handbook template!