-1

I have a range of letters in B2:B5. In A8, I have a formula that repeats each letter x number of times (4 in this case).

I want to do something similar, except I want the whole letter sequence repeated x number of times.

What's the best way to do this?

enter image description here

=XLOOKUP(
SEQUENCE(
SUM(
SEQUENCE(4,,4,0)
)
),
VSTACK(1,SCAN(1,SEQUENCE(4,,4,0),LAMBDA(a,b,a+b))
),
VSTACK(B2:B5,""),,-1
)
Statto
  • 410
  • 3
  • 9
  • In `A8` you should have `=LET(data,B2:B5,Repeats,4, rc,ROWS(data),rs,INT((SEQUENCE(Repeats*rc)-1)/Repeats)+1, INDEX(data,rs))`. In `C8` you want `=LET(data,B2:B5,Repeats,4, rc,ROWS(data),rs,MOD(SEQUENCE(Repeats*rc)-1,rc)+1, INDEX(data,rs))`. – VBasic2008 Aug 06 '23 at 23:03

0 Answers0