Forum Discussion
dipankar_de
Nov 12, 2022Copper Contributor
Using TEXTSPLIT without copy-fill-down
Hello All, I am trying to split "; " separated range of text into columns. The intent is to use one single spill-formula (instead of copy-fill-down) to address each text in the range. I have...
Patrick2788
Nov 12, 2022Silver Contributor
Here's my take:
=LET(matrix,MAKEARRAY(ROWS(Table2),9,LAMBDA(r,c,CHOOSECOLS(EXPAND(TEXTSPLIT(INDEX(Table2[Values],r),";"),1,9,""),c))),HSTACK(Table2['#],matrix))