| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to stack/transpose select rows (cpm)
Given an xls with 2000 rows and data formatted A5:L5 (1R x 12C) as
follows: <PRE AAA BBB CCC DDD EEE FFF GGG HHH III JJJ KKK LLL </pre How would I stack the data so that each row becomes formatted as follows (each remaining "pair" stacks beneath CCC DDD) <PRE AAA BBB CCC DDD EEE FFF GGG HHH III JJJ KKK LLL </pre |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CheckBoxes Stack up when Rows are hidden and unhidden | Excel Worksheet Functions | |||
| Macro to select cells without a certain value and select a menu it | Excel Worksheet Functions | |||
| macro to select and copy rows only containing data | Excel Discussion (Misc queries) | |||
| Select rows in pivot table with macro | Excel Discussion (Misc queries) | |||
| vba macro to perform custom reporting -transpose from rows to columns | New Users to Excel | |||
Linear Mode
