Thread: Extracting multiple words from one cell into individual rows while copying all other data
View Single Post
 
Old 09-30-2015, 01:19 PM
randyaserve randyaserve is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Sep 2015
Posts: 3
randyaserve is on a distinguished road
Default Extracting multiple words from one cell into individual rows while copying all other data
Hi,

I am trying to accomplish the below and wondered if anyone may be able to help out as I have been trying to get a solution for few days but haven't found a good one yet.

I have a table with hundreds of lines like the below:

ID Date Name
1 1/1/15 Joe<br>Mary<br>Steph
...

and I'd like to get it to convert to

ID Date Name
1 1/1/15 Joe
1 1/1/15 Mary
1 1/1/15 Steph

Thanks for any suggestions!

Props to macropod for teaching me how to add a file

Randy
Attached Files
File Type: xlsx Excel Example.xlsx (9.4 KB, 12 views)
Last edited by randyaserve; 10-01-2015 at 06:26 AM. Reason: Adding Excel file (thanks macropod!)
Reply With Quote