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 |
All times are GMT +1. The time now is 02:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com