One way to try ..

Assume data is in col A, A1 down
with one blank row in-between
groups of 3 lines each

First Place Awards
1234 Fifth Avenue
New York, NY 11111

2nd Place Awards
1235 Fifth Avenue
New York, NY 11111

Put in say, C1:

=OFFSET($A$1,ROWS($A$1:A1)*4-4+COLUMNS($A$1:A1)-1,)

Copy C1 across to E1,
fill down until zeros appear, signalling exhaustion of data

Then copy cols C to E and paste special as values either in-situ or
elsewhere

If the data is w/o the single blank rows separating the groups of 3's, put
instead in C1:

=OFFSET($A$1,ROWS($A$1:A1)*3-3+COLUMNS($A$1:A1)-1,)

Then copy across to E1 and fill down as before
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Nickornyk" wrote in message
...
I copied address off the internet. They are all isted in column A.

example:
First Place Awards
1234 Fifth Avenue
New York, NY 11111

How do I get row 2 to column b and row 3 to column c?

What I want.
A B
C
First Place Awards 1234 Fifth Avenue New York, NY 11111

I have 10,000 address all in this one column that I'd like to have
seperated
into 3 columns. I don't have the time to cut and paste.

Any way I can do this?