Thread: Text mailing list: need to transpose to columns; inconsistent number of fields

Hello, forgive me if this is an overly easy issue...

I was given an MSWord based mailing list and I would like to create a table in Excel to use as a mail merge data source. In Word, I eliminated any duplicate rows by inserting a "Z" to indicate the end of each contact entry.

I would normally just transpose all the entries but unfortunately, the fields for each contact are not consistent. For example, the first contact currently appears as follows:

A1: Allen, Peggy
A2: David Perry and Associates
A3: 525 Rt. 73 South, Suite 201
A4: Marlton, NJ 08053
A5: Bus: (856) 596-9400
A6: Bus Fax: (856) 596-9125
A7: E-mail: peggyallen@att.net
A8: Z
A9: Becker, Brady
A10: Adison & Partners Executive Search
A11: Bus: (973) 539-0063
A12: E-mail: brady@adisonpartners.com
A13: Z

I'd like the end result to look as follows:

recruiter format example.jpg

Attached is the full worksheet so you can see it in more detail.

recruiters.xlsx


Thank you in advance for your assistance!

-dlyliny7203