Transpose multiple columns into one column

Hi Ola,

I took a look at your .zip file. And I am not sure if:

1. Your .zip attachment answers my query.
2. Although Sheet 3 (test) looks promising. Is that a solution? You were not able to state that it is an alternative so I don't know if I'll try that one.


I have 400 columns and each column has unique values (cases). I want these cases to be in one variable (column) following the sequence of each case column 1 to column 400 downwards.

Supposed, I have:


A B C
1 4 7
2 5 8
3 6 9

I want these cases to look as:

A
1
2
3
4
5
6
7

Thank you.

http://www.excelforum.com/excel-work...ml#post2450944

I posted my sample worksheet in this link. Thanks.