Formula Help

Question

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.

Kenda · Accepted Answer

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!