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))
One more for the collection
=REDUCE(
"Result",
MAP(list, LAMBDA(v, LAMBDA(IF(SEQUENCE(n), v)))),
LAMBDA(a,v, VSTACK(a, v()))
)Close to what Patrick2788 suggested.