Hello everyone,

I know many may have this same problem, I hope the answer helps a lot of
people.

I have a list of 1000 contacts that are in vertical order, not very
database friendly. I would like to change the contact info so they are in
colums cells not row cells. Some have email address, some dont .
Their is a space between each orginal contact if that helps.I have tried may
methods but none has worked

Example

From this

Joe Smoe
122 W 123 Lake
Phila,Pa 19120
954-633-5656

Billy Bon
122 W 123 Lake
Phila,Pa 19120
954-633-4141

To this

Joe Smoe | 122 W 123 Lake | Philadelphia,Pa 19120 |954-633-5656
Billy Bon | 122 W 123 Lake | Philadelphia,Pa 19120 |954-633-4141

The more suggestions the better . Thank you very much for your help
Carl