| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel TRANSPOSE
Does anyone know how to take 7 rows/20 columns and place into a single column
as the example I have here???? This information is uploaded into our database and while I can transpose the rows to columns, I then have to take the 7 rows and paste them into a single column. It would be great to setup a macro or VB for this one, but I don't know how...??? Please help... Thanks! Example of what I need: 090109 100000.00434 5.00 067 [cs3tm] 090109 100000.00422 15.00 067 [cs3tm] 090109 100000.00612 5.00 067 [cs3tm] 090109 100000.00731 15.00 067 [cs3tm] 090109 100000.00356 5.00 067 [cs3tm] |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why can I not select transpose in excel? | Excel Discussion (Misc queries) | |||
| MS Excel transpose error | Excel Discussion (Misc queries) | |||
| Hi all i need some help on excel transpose | Excel Worksheet Functions | |||
| Hi all need some help in excel transpose | Excel Discussion (Misc queries) | |||
| I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
Hybrid Mode
