How to do converse of Concatenate in Summarize function ?

[Harsh-Goyal]

Hi All,

I recently used Summarize > String > Concatenate option in Alteryx and with that, I concatenated multiple values separated by "," 

Now i want to do the exact opposite based on the concatenated version, how best can I do it any suggestion

Example Initially i converted:

Text           Values

xxx               x1

xxx               x2

xxx               x3

xxw              Y1

xxw              Y2

to 

Text          Values

xxx             x1,x2,x3

xxw            Y1,Y2

Now i want to transform it back to original state:

from this:

Text          Values

xxx             x1,x2,x3

xxw            Y1,Y2

to this: 

xxx               x1

xxx               x2

xxx               x3

xxw              Y1

xxw              Y2

How?

[Aaron_Harter · Accepted solution]

Hi @Harsh-Goyal, 

Check out the Text to Columns tool, configured to 'split to rows':

 

[Harsh-Goyal]

It worked, Cheers!