Address List

  • Thread starter Thread starter joaniemic
  • Start date Start date
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?
 
In B1, try
=OFFSET($A$1,(ROW(B1)-1)*3+COLUMN(B1)-COLUMN($B1),0)
and copy down and across.
 
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

Similar Threads

Need VLOOKUP to Work Two Ways 0
Moving info from rows to columns 2
Convert street address to zip code 1
Critical - Converting Single Column Address Data into Multiple Col 2
Excel- Conditional Formatting 3
Seperating information in a cell 9
Transpose multiple Columns to rows 8
Replace hard return with a delimiter? 3

Back
Top