reformatting matrix into a single column

[fiddle]

Hello,

I have a matrix that looks like this:

1	2	3
4	5	6
7	8	9
10	11	12

And would like to rearrange this data to:

1
2
3
4
5
6
7
8
9
10
11
12

In actuality it's a 110000 x 3 matrix that should become a 330000 x 1 column.
Can anyone help me with this?
Many thanks in advance.

[Ace_XL]

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

[hemesh]

do you want your matrix to move like
1 row 1column then 1row second column then 1 row third column and so on

[fiddle]

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

[AlKey]

Try this array formula

=IFERROR(INDIRECT(TEXT(SMALL(IF(A$1:C$10<>"",ROW(A$1:C$10)*10^4+COLUMN(A$1:C$10)),ROWS(D$2:D2)),"R0000C0000"),0),"")

	A	B	C	D
1	alpha	bravo	charlie	alpha
2	delta	echo	foxtrot	bravo
3	golf	hotel	india	charlie
4	juliet	kilo	lima	delta
5				echo
6				foxtrot
7				golf
8				hotel
9				india
10				juliet
11				kilo
12				lima

[Ace_XL]

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

The formula in post #2 will still work..try it!

@Allkey - I'm not sure having an array formula across 33000 rows is something I wanna try

[fiddle]

The formula in post #2 will still work..try it!

Ha, indeed it id! Thank you very much, you're a hero.
Also thanks to the others who offered their help!