By Shivani Garg
In Excel Transpose function gives option to switch from rows to column and from column to rows .
How To transpose data in excel
Let's start.
>>. Select the range A1:A8, Right click, and then click Copy.
>> Select cell A11, Right click, and then click Paste Special.
>> Check Transpose.
>> Click OK and the Result will be
How to Insert Transpose Function
To insert the TRANSPOSE function, take following steps.
1. First, select the new range of cells , we are selecting A11 here..
>> Type in cell A11 =TRANSPOSE(A2:A8) ** A2:A8 is the range of cells where you want to apply transpose function.
>> Pressing keys CTRL + SHIFT + ENTER.
Result will be
Related >>
Labels:
MS Excel
Shivani Garg