Fill formula but skip everyone 200 cells

[EvonS]

I'd like to use =TEXTJOIN(" | ", TRUE, U2:200) but I'd like it to skip every 200 cells when I fill the formula down. I want to do this because of the limitations of TEXTJOIN. I have over 12K rows to join and TEXTJOIN can't manage that much. Thanks in advance for the help.

 

[Joe4]

I assume that is supposed to be U2:U200, right?

What row is the first formula going in?

 

[EvonS]

What row is the first formula going in?

W1

 

[Joe4]

OK, place this formula in cell W1 and copy down:

=TEXTJOIN(" | ", TRUE, OFFSET($U$2:$U$200,(ROW()-1)*200,0))

 

[EvonS]

OK, place this formula in cell W1 and copy down:

=TEXTJOIN(" | ", TRUE, OFFSET($U$2:$U$200,(ROW()-1)*200,0))

You're awesome. Thanks for responding so quickly.

 

[Joe4]

You are welcome!
Glad I was able to help!

 

[Fluff]

Another option that will spill down

=REDUCE(TEXTJOIN(" | ",,U2:U200),SEQUENCE(12000/200,,201,200),LAMBDA(x,y,VSTACK(x,TEXTJOIN(" | ",,CHOOSEROWS(U:U,SEQUENCE(200,,y))))))

 

[EvonS]

Another option that will spill down

=REDUCE(TEXTJOIN(" | ",,U2:U200),SEQUENCE(12000/200,,201,200),LAMBDA(x,y,VSTACK(x,TEXTJOIN(" | ",,CHOOSEROWS(U:U,SEQUENCE(200,,y))))))

Wow. Thanks

 

[Fluff]

You're welcome.