text split
Posted: Thu Jul 25, 2024 5:00 pm
Hi there
Please solve this to split text
thanks
Please solve this to split text
thanks
...
D2
=HSTACK(INDEX(A1:A4,TOCOL(ROW(B2:B4)/(MAP(B2:B4,LAMBDA(x,LEN(x)-LEN(SUBSTITUTE(x,",",""))+1))>=COLUMN(A1:Z1)),2)),TEXTSPLIT(TEXTJOIN(",",1,B2:B4),1,","))
Bigcat9
BKK Thailand