Forum Discussion

ElRafaVaz33's avatar
ElRafaVaz33
Copper Contributor
May 20, 2022
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 ...
excel
Formulas and Functions
office 365
  • mtarler's avatar
    mtarler
    May 20, 2022

    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))

     

Patrick2788's avatar
Patrick2788
Silver Contributor
May 20, 2022
Presuming names in A1:A3:
=TOCOL(CHOOSECOLS(A1:A3,1,SEQUENCE(3,1,1,0)))

*TOCOL and CHOOSECOLS are available with Insider (beta channel).
  • ElRafaVaz33's avatar
    ElRafaVaz33
    Copper Contributor
    May 21, 2022
    Thanks all for your answers! There definitely seems to be multiple ways to address this 🙂

Resources