split concatenated values into multiple columns
Hi,
Need help with splitting the concatenated values into multiple columns
I know we can use Cell Splitter, however it can be used for 1 column at a time.
I wanted to run on multiple columns which have concatenated values.
In the image given below, “|-|” is my delimiter, similar to this column I’ve other columns with different concatenated values…
Here is the output I’m looking for
It is been quite few months, and I forgot how to use variables and loop through the columns :sweat_smile:
Thanks