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

  • Thread starter Thread starter Emma
  • Start date Start date
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.
 
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
 
Please restate your question paying attention to what is a row and what is a
column. Your original layout and the layout desired.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transpose, but how? 0
Having Blank Cells, etc. ? 1
Showing Letters For Column Headers Rather Thann Numbers ? 1
counting blank cells within two columns 2
Importing data from Excel worksheet into Excel template 2
SUM - IF - AND 7
Return MAX value from column B and Name from column A 2
Possible to "understand and pull" highest value from column B..... 3

Back
Top