Move Rows to Columns

D

DOwens

I have a list of names and addresses that are in rows. Does anyone know of
way to move the address and city state zip to columns so that I can do a mail
merge and print labels. I know I could cut & paste but that would take a
long time.

Example
Name1
Address 1
City state zip1
Name2
Address 2
City state zip2

if name1 is in a2
I would like for address 1 to go to B2 and city state to go to c2
 
G

Gord Dibben

Are these data consistent?

i.e. 3 rows per address

If so, enter this in B2 and copy across to D2 then select B2:D2 and drag/copy
down until you get zeros.

=INDEX($A:$A,(ROWS($1:1)-1)*3+COLUMNS($A:B))

When happy, select columns B:D and copy>paste special>values>ok>esc.

Delete Column A


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top