Forum Discussion
Solved
Create array with repeated values from another array
The screenshot below pretty much summarizes what I need to accomplish. Say I have the "Original array" below. I need to come up with a formula that will create another array (the "Resulting array" ...
There are a number of ways. Here is one using 365:
=CHOOSEROWS(Table1,INT(SEQUENCE(ROWS(Table1)*count,,1,1/count)))
