Assuming the data starts in A1; and that there are 3 lines of info for every
person:

In B1 ( or other cell) enter =INDIRECT("A"&3*ROW($A1)-2)
Copy this across to D1
Modify C1's formula to =INDIRECT("A"&3*ROW($A1)-1)
Modify D's formula to =INDIRECT("A"&3*ROW($A1))
Copy these three formulas down as far as needed (to row N/3 where N is the
number of entries in column A
If you wish you can now use Data | Text to columns on column D to separate
Town, State and Zipcode
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"MEAD5432" wrote in message
...
I have a column of information. How can I move the data from the a cell in
the column into a cell in a row? For instance:

Currently
Steve Smith
1 some road
some town, CA, 555555
John Anderson
2 some blvd
this town, NY, 555555
John Doe
3 this pkwy
where, TX, 555555


What I want
Steve Smith 1 some road some town, CA 55555
John Anderson 2 some blvd this town, NY, 555555
John Doe 3 this pkway where, TX, 555555

Any help would be appreciated.

Thanks.