Reorganizing Data in Excel from Rows to Columns
 

I have an Excel File filled with data like this: (with a bit of data
changed for anonymity)

ALBERTS, Shannon K.,
Managing Dir/Investor Relations & Assistant Secretary
Alaska Airlines, Inc.
Box 55555, Seattle, WA 55555
(206) 555-5218 FAX: (206) 555-5807


ALBO, Sandra,
President
Pro Advantage
555 Fifth Ave., Ste. 555, New York, NY 55555
(212) 555-0222 FAX: (212) 555-2666

What I want to output is this:

Name Title
ALBERTS, Shannon K., Managing Dir/Investor Relations & Assistant
Secretary
ALBO, Sandra, President



Company Address
Alaska Airlines, Inc. Box 55555, Seattle, WA 55555
Pro Advantage 555 Fifth Ave., Ste. 555, New York, NY
55555

Phone Fax
(206) 555-5218 (206) 555-5807
(212) 555-0222 (212) 555-2666

Email


Each person's data is separated by a blank row
Some people do not have emails