Comma Separated Values to Multiple Records/Rows

[rajeshboyapati]

Hi All,

I am getting excel file with multiple columns. Among those one column is having comma separated values. I want to convert comma separated values into multiple rows. Please fins the sample source data here

Col1	Col2	Col3	Col4
A	B	C	Alteryx,Informatica,Tableau,Qlikview
X	Y	Z	Alteryx,Tableau,Qlikview
P	Q	R	Alteryx,Tableau

Target Output should be as below:

Col1	Col2	Col3	Col4
A	B	C	Alteryx
A	B	C	Informatica
A	B	C	Tableau
A	B	C	Qlikview
X	Y	Z	Alteryx
X	Y	Z	Tableau
X	Y	Z	Qlikview
P	Q	R	Alteryx
P	Q	R	Tableau

Please help me to get the solution for my requirement. If possible please provide alteryx workflow.

With Regards,

Rajesh

[LordNeilLord · Accepted solution]

Hey @rajeshboyapati

In the text to columns tool you can choose the option "split to rows" this will give you the answer you need

[rajeshboyapati]

@Lord,

Thank you very much for your kind response.