to convert columns to rows having mulit independent group columns

to convert columns to rows having mulit independent group columns

Post by UXVhY3 » Thu, 24 Aug 2006 04:59:01


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

Post by Gord Dibbe » Thu, 24 Aug 2006 07:20:28

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 < XXXX@XXXXX.COM >