Thread: Parse Text Separated by ; to next Row

Hello All,
I am using Excel 2007 and have the following problem (file attached with Before and After)

I have several thousand rows of Data with Col A as Account_No and Col C having two email IDs for the same Account separated by a ;
eg

account_no BAL Mail IDs
977265891 1865 accounts@ashraayenterprise.com;bbire...tiorganics.com
977356854 346 arun.607@rediffmail.com;sunilthakur2000@yahoo.com
...
...
...
...

I wish to have it like the following
account_no BAL Mail IDs
977265891 1865 accounts@ashraayenterprise.com
977265891 1865 bbirewar@multiorganics.com
977356854 346 sunilthakur2000@yahoo.com
977356854 346 arun.607@rediffmail.com


Can anybody help me with this

'ROWS TO COLUMNS
Here's a macro for expanding rows of data to multiple rows parsing out the delimited values in one column while duplicating all the others.

Rows to Columns - Part 2

Just edit the Col = 3 run it on a copy of your data, make sure the titles are in row1, it should do what you want. There's a sample workbook too you could drop your data into and test it out.

I installed it into your sheet, just click the button.