Multiple Column's data formated into one column

[WildeWebPublishing]

----------------------------------------------------------
A B C D E F G H I
1| 2643|3677|3678|3679|3680|3681|3682|3685|4219|
2| 8628|8647|8659|8660|8661|8662|8783|8824|8859|
----------------------------------------------------------
I need a way to "quickly" move all of the data above into a nice column. I.E.
___A___
1|8628|
2|8647|
3|8659|
4|8660|
5|8661|
6|8662|
7|8783|
8|8824|
9|8859|

Any thoughts. I have about 300 x 5000 cloumns to do this to and I wont copy and paste each row.

Dave
WildeWebPublishing
The best way to eat chicken is when it is dead.

 

[mscallisto]

Select all rows (or one row) then edit > copy

go to a new sheet and in A1 Edit > Paste special > check the transpose box > OK


I got this neat trick from XLBO back in June

turns rows to columns...hope it helps

 

[WildeWebPublishing]

Almost but not quite what I need

Dave
WildeWebPublishing
The best way to eat chicken is when it is dead.

 

[mscallisto]

What's it missing?