Changing Excel Column Data to Row

While I was dealing with some climate excel data (rainfall) it was recorded as follows,
2000 - Jan        10
2000 - Feb        16
2000 - Mar        1
2000 - Apr        14
2000 - May        19
2000 - Jun        12
But I wanted data in below format,

Jan        Feb         Mar        Apr        May         Jun  
10         16           1            14            19           12
So the steps are as follows,
Select the coloumn,
Select Copy
Right Click
Paste Spatial 
Select Value (in Paste) , and Transpose
Click OK