Excel 2007 :: Consolidate Several Columns Into One (not Concatenate)

I have the following situation and I'm trying to do this using a PC with Excel 2007.

I would like this:
T
N
O
O
C
O
E
I
M
I
T

[Code] ........

To look like this:

T

H

A

N

K

[Code] .........

This procedure will become part of a macro. The number of rows will vary but the number of columns will be the same (11 columns). I don't care too much about the order since I can later sort. As long as the data from all columns in now in one column.