Thanks in advance. How do I turn one column into several by looking at a particular character, i.e. a comma.
Turn one column:
Lang
English, Spanish, Russian (the number of languages in this one column could vary)
into many columns:
Lang1 Lang2 Lang3
English Spanish Russian
However, I may only need the first two but I guess if they could all be accounted for - that would be ideal. Thanks for your help.
Solved! Go to Solution.
Hey @Brad1! In the Parse category in Alteryx, use the Text To Columns tool. Use Lang as your field to split and use a comma as the delimiter. Hope this helps!
Seems like u changed your picture. Thanks for your help!