| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
turn rows into columns
I have an excel file with hundreds of rows as follows:
A1= Name, A2 = George Smith B1= Firm, B2 = Sears C1=Phone number, C2 = 519-555-4545 E1= Name, E2= Jane Brown F1= Firm, F2 = IBM G1=Phone number, G2 = 905-555-4545 I would like the end result to in 'column' format (so every record on each row) Column Headings: Name/Firm/Phone numbers George Smith/Sears/519-555-4545 Jane Brown/IBM/905-555-4545 How can i achieve this...i have about 500 records. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert columns to rows & rows to columns | Excel Discussion (Misc queries) | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| How to keep rows together when sorting columns? | Excel Worksheet Functions | |||
| Printing problems with columns and rows | Excel Discussion (Misc queries) | |||
Threaded Mode
