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

Excel Example.xlsx (9.4 KB, 12 views)