Forum Discussion
Solved
How to convert csv list to column WITHIN an excel Table (no VBA)
Hello, I am looking for an equation that does the following: Change Group Change Group Conversion 5,6,7,8,9 5 5,6,7,8,9 6 5,6,7,8,9 7 5,6,7,8,9 8 5,6,7,8,9 9 ...
Perhaps
=IFERROR(INDEX(TEXTSPLIT([@[Change Group]], ","), ROW([@[Change Group]])-ROW(Analysis_T[[#Headers],[Change Group]])), "")
Perhaps
=IFERROR(INDEX(TEXTSPLIT([@[Change Group]], ","), ROW([@[Change Group]])-ROW(Analysis_T[[#Headers],[Change Group]])), "")