How do I take comma delimited multiple choice selections and separate them into individual rows?
Options
Victor_157889
Posts: 1
in Questions
If I have to select multiple choices in a field and them come back as comma delimited in one cell of my data table, how can I separate these values into unique rows?
Tagged:
0
Answers
-
Hi @Victor_157889,
I would use the "Text to Table" action. This will convert the list to rows. Then pair it with "Copy a table to another table" to place those choices in the final location.https://help.catalytic.com/docs/tables-convert-text-to-a-data-table/
https://help.catalytic.com/docs/tables-copy-a-table-to-another-table/0