Transpose large data

[Saideesh]

I am tired of doing transpose manually...looking for any help to do it using VBA code. I have the around 200k+ lines...and similar data i need to do it going forward as well. Any help to is greatly appreciated.

Actual data:
1 2 3 4 5 6
1 2 3 4 5 6
1 2 3 4 5 6
1 2 3 4 5 6
1 2 3 4 5 6
1 2 3 4 5 6
22 33 44 55
22 33 44 55
22 33 44 55
22 33 44 55
aa bb cc
aa bb cc
aa bb cc
aa bb cc
33 44 55 66 77 88 99 1001
33 44 55 66 77 88 99 1001
33 44 55 66 77 88 99 1001
33 44 55 66 77 88 99 1001
33 44 55 66 77 88 99 1001
33 44 55 66 77 88 99 1001
33 44 55 66 77 88 99 1001
33 44 55 66 77 88 99 1001

OUTPUT:
1
2
3
4
5
6
22
33
44
55
aa
bb
cc
33
44
55
66
77
88
99
1001

 

[Hui]

Saidash

Firstly, Welcome to the Chandoo.org Forums

Please see the following

Select the Upper Left corner of your data


Press Alt+_F8
Select Transpose_Data and click RUN

The Data will be put into the column to the Left of the selected Cell
so make sure there is no data in that Column

Enjoy