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
Bookmarks