Reorganizing Data in Excel from Rows to Columns

V

vinhdang

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
(e-mail address removed)

ALBO, Sandra,
President
Pro Advantage
555 Fifth Ave., Ste. 555, New York, NY 55555
(212) 555-0222 FAX: (212) 555-2666
(e-mail address removed)
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
(e-mail address removed)
(e-mail address removed)
Each person's data is separated by a blank row
Some people do not have emails
 
Top