How to convert row values to coulmn values in Excel

I have an excel with 10 rows and 20 coulmns but i want开发者_JS百科 a new excel in which rows values in coulmn values

Copy the values in the rows and then go to Edit, Paste Special and then tick the "Transpose" option.