Converting a matrix into a single column

Hi,

I need a macro that allows me to select a matrix of cells and converts it into a single column elsewhere, pasting the second column below the first and so on. Is it possible to select the matrix, hit a macro key and then paste it in my selected location? Thanks so much

Thanks for that. However its not exactly what I mean. I guess my querry was vague.
It may only be possible to copy a matrix, then select a cell where the output is to be pasted, and then hit the macro button. This pastes the output from the matrix in a single column. Thanks

Please Login or Register  to view this content.

Wow you are very fast. Thanks heaps. It almost works. I can take a single column but not a matrix. Some syntax error.

You want the columns of the matrix to appear one below the other, in a single column?

Pretty much. First column of the matrix on the top, the second column of the matrix below the first column as so forth.

1 11 111
2 22 222
3 33 333

into


1
2
3
11
22
33
111
222
333

You're a legend. Thanks so much. It works

You're welcome, glad it worked for you.

Could you help me do the exact opposite? I'm looking at a column several hundred rows long, and would like to see it in several smaller columns if possible.
For example.
a
b
d
e
f
g
h
i
j

to

a d g j
b e h
c f i

Optimal column length would be 21, but somehow having this as a option to chose from would be steller.

Thanks