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

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 <[email protected]>
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