Select the range of cells you want to transpose
Copy the selected cells
Click the destination cell where you want the transposed data to start
Right-click and choose Paste Special
Select Transpose
Click OK
Or use the TRANSPOSE function
Select an empty range with the transposed size
Type =TRANSPOSE(original_range)
Press Enter in Excel 365 or Ctrl+Shift+Enter in older versions
