1: Select your data
2: Copy the selected range
3: Click anywhere out side selected range
4: Right Click -> Paste Special -> Values also Check "Transpose" option
5: Click OK


HTH
------------------