Transpose huge data from horizontal to vertical

Hello
Without any VBA codes, follow these steps :
* Select A1 >> Press Ctrl + Shift + Right Arrow (To select the range A1:ADD1)
* Right-Click >> Copy
* Select A3 >> Right-Click >> Paste Special >> Select "Values" option and check "Transpose" and finally click "OK"
Help.png

And if you recorded the steps you can get similar lines

Please Login or Register  to view this content.

Or if the code is needed, because it's a part of larger project, you can do for instance this way:

Please Login or Register  to view this content.