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.

 

[selant]

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

Entered formula in F 2977 and pull down..

 

[RoryA]

As written it needs to be entered in row 1. Otherwise you will need to adjust the ROW() parts to account for your start row.

 

[selant]

works great now. thank you very much