Quote Originally Posted by Ace_XL View Post
With your matrix data in columns A:C use

=INDEX(A:C,CEILING(ROW(A1)/3,1),MOD(ROW(A1)-1,3)+1)

Copy down
I guess I should have made clear that the entries in the matrix are not actually numbers, but pieces of text

So:



alpha bravo charlie
delta echo foxtrot
golf hotel india
juliet kilo lima

should become

alpha
bravo
charlie
delta
echo
foxtrot
golf
hotel
india
juliet
kilo
lima

Sorry about that. Many thanks in advance