Transpose in MS Excel









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
  

Must read for you :