| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need a macro to transpose multiple columns A1-Z1, A2-X2 etc
I have a spreadsheet that has figures in A1 to Z1, A2 to X2, A3, A5 to H5 to
A968, and I need all of these entries transposed to one column in the same order as they are in the columns ie B2 to Go to A2, C2 to go to C2 etc I can do this manually line by line which will take me forever. I need a macro to copy each row and transpose this to the next available cell in column A |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Text to Columns" for many columns in Excel 2003 | Excel Discussion (Misc queries) | |||
| Error using a macro to print multiple pages. | Excel Discussion (Misc queries) | |||
| macro to compile columns on multiple sheets | Excel Discussion (Misc queries) | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
Threaded Mode
