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

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.

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

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

On Jun 27, 5:21 pm, Emma wrote:
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.

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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Emma" wrote in message
...
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.