Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transpose to break up one long row to many?
Hi All
I have a problem i hope you can help with. The sheet i have has rows of many columns, what i need to do is leave the first 5 columns of data and underneath that row insert the next 5 columns of data, then the same again with 4 columns, 5 columns, 4 columns. One the has done move to the next original row and repeat till the end. Any suggestiosn on a macro to help? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to transpose and concatenate long list in one column? | Excel Worksheet Functions | |||
Interrupting long calculations in Excel? Hi all, I am having a verylong calculation in Excel using VBA. Of course I know I can hit ESC orCTRL+BREAK to interrupt the VBA program. But I found due to too long runningprocess, the Excel window stop to | Excel Discussion (Misc queries) | |||
Transpose several columns to one long column | Excel Discussion (Misc queries) | |||
One VERY LONG row... break it down? | Excel Discussion (Misc queries) | |||
How to transpose a long list of text across cells | Excel Discussion (Misc queries) |