Forum Discussion
Solved
Creating a dynamic repeating sequence of arrays
Hi Excel community, I'm trying to find a way to create a dynamic array of repeating cells. I was attempting a similar technique on Google Sheets where you can use a Rept and TextJoin to create a ...
ElRafaVaz33 There are lots of possibilities. Here is one:
=LET(in,F1:F6,rep,G1,s,SEQUENCE(ROWS(in)*rep,1,0),INDEX(in,QUOTIENT(s,rep)+1))
The attached workbook contains the basic CHOOSECOLS/TOCOL solution as well as the REDUCE/VSTACK approach. The main intention, however, was to test a function BYROWλ against the different use cases. The function description is
/* DESCRIPTION: Implements a version of BYROW that will return an array of arrays */
It is used first simply to create the 4 repetition problem and then the variable repetition version. In each case the array of array problem of Excel is solved out of sight of the user.
Note: The variable repetition version would appear neater were the MAP helper function generalised but I have yet to tackle that 