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

Question

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.

Output File-1.xlsx

Input File-1.xlsx

DataNath · Accepted Answer

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.