Snasui Excel Forum

Hi there

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

thanks so much