How do I fit columns A and B to column C with A on top of B?

E

Emma

I have 12 columns of data that I want go into one column; Column A is first,
then Column B follows underneath, then Column C, etc. using Excel.
 
V

vezerid

Say you want to start your serialized data in cell AA2. Enter in AA2
the following formula (assuming data in A2:L101):

=INDEX($A$2:$L$101,INT((ROW()-ROW($AA$2))/12),MOD(ROW()-ROW($AA$2),
12))

Copy down.

HTH
Kostis Vezerides
 
D

Don Guillett

Please restate your question paying attention to what is a row and what is a
column. Your original layout and the layout desired.
 
Top