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?

Copy Paste Special Transpose


"joaniemic" wrote in message
...
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.
--
David Biddulph

"joaniemic" wrote in message
...
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?

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

On Wed, 30 Apr 2008 10:01:55 -0600, "Gaurav" wrote:

Copy Paste Special Transpose


"joaniemic" wrote in message
...
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?