I have a workbook of names and addresses. All information is in column A...

John Doe
111 5th st.
New York, NY
Joe Smith
1st St. E
Chicago, IL

etc.

I want to convert this entire workbook to column form as follows,

John Doe 111 5th St New York, NY
Joe Smith 1st St. E Chicago, IL

Is there a way for me to do this without using "Paste Special" and
"Transpose" for each individual entry.....or tediously moving each entry one
by one?

bootsy