Text to Columns and duplicating the row for the all the values involved in the column

[1997Mahendra]

Hello Everyone,

Could you please help me in solving the below one?

This is what the sample data looks like.

And I need the output to be like the below one.

After using the text to columns to separate the countries, I need the same row to get duplicated for the all countries involved.

Appreciate if you can let me know how this can be done in designer. Thanks for your time and help in advance.

[DataNath · Accepted solution]

Hey @1997Mahendra, if I’m understanding this right then instead of selecting the ‘Split to Columns’ radio button in the Text to Columns configuration, you can press the ‘Split to Rows’ button. Keep the delimiter etc the same. After that you can just use a Select tool to change column names.

[1997Mahendra]

Thank you so much @DataNath, It works!