I am copying a phone/address directory and want to put it in columns.

This is how it looks when I copy it to excel:

Doe, Jane Ms.
Title/Position: Vice President
Department: Department of Marketing
Office Location: New York
Email:

Doe, John
Title/Position: President
Department: Department of Business
Office Location: New York
Email:

How do i get name to column a, title into column b and so on?

Thanks