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)))
Here is another approach using MAKEARRAY().
=MAKEARRAY(ROWS(B4:C6)*E5,COLUMNS(B4:C6),LAMBDA(r,c,INDEX(B4:C6,ROUNDUP(r/E5,0),c)))