| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to convert columns to rows having mulit independent group columns
i have a list to over 1000 contacts in column form. i would like to convert
these contact into row from. Microsoft lets you convert one group at a time. If i highlight more than one group and paste special they come up side by side on same line. I would like each group to come up the right side of each contact |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
to convert columns to rows having mulit independent group columns
Quacy
There are ways to do what you want. Copy and paste a sample of your layout. How many rows per contact? Any blanks in between? Example of layout could like so................or other? firstname lastname address city state zip <blank or not firstname lastname address city state zip Gord Dibben MS Excel MVP On Tue, 22 Aug 2006 12:59:01 -0700, Quacy wrote: i have a list to over 1000 contacts in column form. i would like to convert these contact into row from. Microsoft lets you convert one group at a time. If i highlight more than one group and paste special they come up side by side on same line. I would like each group to come up the right side of each contact |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert rows to columns | Excel Worksheet Functions | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| Repeating Rows and Columns on each page of print out | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
| how do you group and ungroup rows or columns in new Excel? | Excel Worksheet Functions | |||
Linear Mode
