View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sandy_eggo sandy_eggo is offline
external usenet poster
 
Posts: 2
Default 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