Consider there are two columns in excel:Name and Country There must be two countries for a name, like:(In name column)Tom and (in Country) India,US. What i want is, in the above mentioned case, if there is a comma in the Country column then it should be displayed in the next row of the same column and the Name column should be resized as per both the country

And the name should be centred to both the countries as displayed in the image below

Actual data and Desired Output

0 Answers