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.

 

[SteveO59L]

Have a look at Transpose

 

[selant]

Have a look at Transpose

hi steve,
i know transpose but it works for single line i think, or it doesnt give me the order I want. I dont want the list in following format :

A1
A2
A3
A4
...
B1
B2
B3
B4
...
C1
C2
C3
C4

 

[SteveO59L]

Will it always be 3 columns to 3 rows ?

 

[selant]

Will it always be 3 columns to 3 rows ?

I have 180 rows and 2980 columns of data to sort.

 

[RoryA]

That's a lot more than 5000 names! I hope you have Excel 2007?

 

[SteveO59L]

How many ?. Are you sure ?

 

[selant]

That's a lot more than 5000 names! I hope you have Excel 2007?

Yes its excel 2007. But no problem i can divide the list into smaller files in case of a need.

 

[selant]

How many ?. Are you sure ?

Yes steve, its true approximately 536400 names

 

[RoryA]

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.