Just something that I discovered today, while helping out a friend. How can I convert horizontal data into vertical? After googling in the internet, I got the answer:

1> Highlight and copy the desired data (horizontal or vertical)
2> Left click the desired location to copy the data to.
3> Right click >> Paste special
4> Check on the Transpose and OK

And, voila!! your data is transposed.. ^_^