| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Converting rows to columns on a large scale
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing problems with columns and rows | Excel Discussion (Misc queries) | |||
| Converting Rows to Columns? | Excel Discussion (Misc queries) | |||
| Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
| interchange columns with rows | Excel Discussion (Misc queries) | |||
Linear Mode
