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
