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: [email protected]
A8: Z
A9: Becker, Brady
A10: Adison & Partners Executive Search
A11: Bus: (973) 539-0063
A12: E-mail: [email protected]
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
Bookmarks