Button to make X number of copies of row

[Pch]

@Scott_Collier-Weir

You can also simplify your formula using the new DuplicateRows() formula.

Old habits die hard … I completely forgot about DuplicateRows()
Thanks for the reminder

Here’s practically the same sample but using DuplicateRows() instead, just to illustrate …

Just in case @Michael_Forsman, this topic helped me a lot when I was struggling with FormulaMap() / ForEach() :

FormulaMap() : When and where?

@Pch Good discussion. Tossing this in for anyone else having this question. List(2,3,4).FormulaMap( CurrentValue * 2 ) 4,6,8 This is the new list comprised of each value from the original list transformed by the formula invoked in FormulaMap(). FormulaMap() is a forEach() loop that returns values. For each value in a source list, FormulaMap() maps a formula to each one of those values, meaning that it runs that formula on each value in the list. The results are returned in a n…