Change the order of my name list

[selant]

I have a list of names and they are in the following format :

A1     B1     C1
A2     B2     C2
A3     B3     C3
A4     B4     C4
A5     B5     C5

How can i list them in the following order ?

A1
B1
C1
A2
B2
C2
A3
B3
C3

P.S : This is quite a long list containing about 5000 names in total.

 

[mikerickson]

Does each row have the same number of columns?

 

[selant]

Basic formula is like:
=INDEX(Sheet2!$A$1:$C$12,INT((ROW()-1)/3)+1,MOD((ROW()-1),3)+1)
adjust the table range and change the 3s to 2980.

shall i write the formula in a new sheet (For example, into A1) and pull down the formula to the A536400 ?

 

[selant]

Does each row have the same number of columns?

yes its true. exactly the same.

 

[RoryA]

Yes, start in A1 and copy down.

 

[selant]

The following formula didnt work as desired, i dont know where i made the mistake :

=INDEX($F$1:$GC$2976;INT((ROW()-1)/2976)+1;MOD((ROW()-1);2976)+1)

It prints all the columns in a row but doesnt jump to the second row to operate..

 

[RoryA]

What happens in row 2977?

 

[selant]

what happens in row 2977?

#ref

 

[RoryA]

Ah, I think you have your rows and columns reversed in your question! Replace the 2976 with 180.

 

[selant]

My range is F2:GC2976

=INDEX($F$2:$GC$2976;INT((ROW()-1)/180)+1;MOD((ROW()-1);180)+1)

This code seems to be working somehow, it starts listing from AP18..

AP18
AQ18
..
..

 

[RoryA]

Where does the output start? (i.e. where did you enter the formula?)