If feel any problem in this guide then please use comment box. I hope you like this Switch or Transpose Row And Column Data guide from which you will be able to easily Switch or Transpose Row And Column Data without any extra efforts. Step 4: The data of range A1:C5 transpose and shows in cells F1:J3. Step 2: Click Formula > Lookup & Reference > Select Transpose Function Step 3: Select the range A1:C5 in Array box then press Ctrl + Shift + Enter Key You have to take following steps to use this function Syntax of TRANSPOSE function: = TRANSPOSE (array) array – It is a range of cells or values which you want to transpose. Must Read: MS Excel : Vlookup Function with a Spreadsheet If you would like to apply additional formatting at that time, you can. 4) Select the arrow next to the Paste button in your ribbon and choose Transpose. 3) Go to and click the cell where you want to paste your data. The TRANSPOSE function is also used to convert rows copied data into columns and columns copied data into rows. You can do this by either clicking Edit from the menu and selecting Copy or using Command + C on your keyboard. You can also use Transpose function from Lookup and Reference category in Formula Tab. Step 5: After choosing this option range (F1:J3) covert into rows to column wise and column to row wise data like this. Step 4: Click Paste button -> Click Transpose button or you can also select Transpose option in Paste Special dialog box. Step 3: Take cursor on new location in which you want to view the result. Step 2: Press Ctrl + C or you can also click Copy button in Home Tab.

Where is the transpose button in excel