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.