Thread
:
Reorganizing Data in Excel from Rows to Columns
View Single Post
#
1
Posted to microsoft.public.excel.programming
[email protected]
external usenet poster
Posts: 2
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
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]