ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   macro to stack/transpose select rows (cpm) (https://www.excelbanter.com/excel-discussion-misc-queries/217152-macro-stack-transpose-select-rows-cpm.html)

sandy_eggo

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