| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 Each person's data is separated by a blank row Some people do not have emails |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert columns of data to rows in excel? | New Users to Excel | |||
| Can I rotate data in Excel table (rows to columns, and vv)? | Excel Discussion (Misc queries) | |||
| Move data from rows to columns in Excel | Excel Programming | |||
| Reorganizing rows into groups | Excel Programming | |||
| Skipping cells while reorganizing data | Excel Discussion (Misc queries) | |||
Hybrid Mode
