| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transpose multiple Columns to rows
Hi,
I know if I have few columns I can transpose it to rows by using the function "Transpose". But if I have hundreds of columns that content the same information, how can I transfer them to Rows. Please see the sample below. Name MICRO ABRASIVES CORP. City WESTFIELD Address 720 SOUTHAMPTON RD., PO BOX 669 Zip Code 01086-0669 Region MA Tel (413) 562-3641- Fax (413) 562-7409- Name FINISHING SOLUTIONS INC. City WESTFIELD Address 103 SERVISTAR INDUSTRIAL WAY Zip Code 1085 Region MA Tel (413) 568-3765- Fax (413) 572-4088- Name O S WALKER COMPANY City WORCESTER Address 20 ROCKDALE STREET Zip Code 01606-1995 Region MA Tel (508) 853-3232- Fax (508) 852-8649- Thanks, Michelle |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRANSPOSE ROWS TO COLUMNS | Excel Discussion (Misc queries) | |||
| Transpose columns to rows using first columns repeated. | Excel Worksheet Functions | |||
| Transpose not working rows to columns | Excel Discussion (Misc queries) | |||
| How do you transpose rows to columns? | Excel Discussion (Misc queries) | |||
| how do I transpose columns and rows | Excel Discussion (Misc queries) | |||
Threaded Mode
