to convert columns to rows having mulit independent group columns

[Quacy]

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

 

[Gord Dibben]

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