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
|