Address List

[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?

 

[Gaurav]

Copy > Paste Special > Transpose

 

[David Biddulph]

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

 

[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