Comma separated values into the new Rows

[GouthamVijay]

Hey Folks,

Whenever there are values which is separated from the comma then it has to be entered in the next row...

Input:

Expected Output:

Regards And Thank You

[PhilipMannering · Accepted solution]

Check out the Text to Columns Tool. There's an option to split to rows.

[messi007]

@GouthamVijay,

Please see below :

Text tocolumn with Split to rows : 

Data cleansing to remove leading white space.

Attached the workflow,

Regards,

[flying008]

Hi, @GouthamVijay 

So easy please see that below:

[ddiesel]

Hi @flying008!

Love that you responded with a gif! I never considered doing so, but this brings the solution to life!