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

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