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
Check Transpose
Click OK
Use the TRANSPOSE function if you want a dynamic formula
Enter `=TRANSPOSE(range)` in the target area
Press Enter in Excel 365 or newer
Press Ctrl+Shift+Enter in older Excel versions if required