Thank you for your response but I couldn't get the formula to work. When
inputting the formula in b2, c2 or d2 I received a row reference error
message which pointed back to (Row(R[-1]C[-1])) with Row[reference] error. I
literally used copy/paste so that I wouldn't goof.
I am not familiar with this function, so I am lost.
Thank you
Northwoods
"Gazeta" wrote:


U¿ytkownik "Northwoods" napisa³ w
wiadomo¶ci ...
I have 37, 800 rows and 1 column. Column A is as follows:
A1 George Brown
A2 1234 Street
A3 Browntown, USA 00234
A4 blank
A5 blank
A6 blank
A7 Betty Smith
A8 2345 Avenue
A9 Thistown, USA 00987
And the pattern repeats for the next 37,800 rows. I need to get 3 columns
setup.
A1: Name
B1: Address
C1: City, State Zip
I have a little knowledge of VBA but on this one I don't know where to
start.
Any suggestions would be very appreciated.

in b2 insert formula
=INDIRECT(ADDRESS(ROW(R[-1]C[-1])*6+1,1))
c2
=INDIRECT(ADDRESS(ROW(R[-1]C[-1])*6+2,1))
d2
=INDIRECT(ADDRESS(ROW(R[-1]C[-1])*6+3,1))
and copy them down as u get all addresses
mcg
mcg