Address List

J

joaniemic

I have a list of addressees where the line is in one row, the street address
in the next row, and the city, state, zip in the next. Is there a way to
convert these three across 3 columns?
 
D

David Biddulph

In B1, try
=OFFSET($A$1,(ROW(B1)-1)*3+COLUMN(B1)-COLUMN($B1),0)
and copy down and across.
 
G

Gord Dibben

What if there are 20,000 sets of these through 60,000 rows?

Would you be willing to drop over and do it?


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