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?