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 |
#2
|
|||
|
|||
If the layout is always 3 rows per address, you can put this in B1 and copy to
the right. Then copy down (until you run out of data) =INDEX($A:$A,MOD(COLUMN()-2,3)+1+(ROW()-1)*3) Bootsy wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting rows to columns on a large scale | Excel Discussion (Misc queries) | |||
Printing problems with columns and rows | Excel Discussion (Misc queries) | |||
Converting Rows to Columns? | Excel Discussion (Misc queries) | |||
Convert multiple columns to rows | Excel Worksheet Functions | |||
interchange columns with rows | Excel Discussion (Misc queries) |