| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
transpose a column into many rows
I have a file with one column as follows:
Name Address Address2 City, State, Zip Name Address Address2 City, State, Zip etc. I need to transpose into columns for mail merge - so transpose the 4 rows into columns, then go down a line, transpose into columns, etc. so each address is on a new line. I tried using the TRANSPOSE function, but I can't get it. Any thought? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
| Vary the column widths for different rows | Excel Discussion (Misc queries) | |||
| how do I transpose columns and rows | Excel Discussion (Misc queries) | |||
| repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
| how do I easily convert a single column of text (multiple rows si. | Excel Discussion (Misc queries) | |||
Threaded Mode
