Transpose multiple columns into one column

I hate to bother you guys with such a simple request for help. And, I tried to search for a solution previously posted here but, apparently, I did not know the right search terms I my searches yielded nothing relevant. Again, sorry.

I have a simple problem. I need to take about 8 - 10 columns of 13 digit numbers and transpose them into a single column of the same numbers. And, I need to keep those numbers which were originally in a row in sequence in the new column if I can.

The array, if you want to call it that, does not have the same number of columns as rows. As I said above the columns number only as much as perhaps 10 but the rows could be many thousands.

Thanks for any help you might provide. And, again, sorry to bother you guys and gals with such a trivial problem.

LongFisher

I wasn't sure what you mean't so I'll bother you with a few options.
Hope it's close to what you wanted
//Ola

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.