In the attached workbook, I am trying to separate the paysource column if there are multiple values separated by commas and keep the rest of the columns the same.
In rows 1/2 I have the raw data. What I am trying to achieve is in rows 6-8.
How would I achieve this in Alteryx?
Text to Columns tool will do the trick! Split that column based on the delimiter but Split to Rows will be the selection