back to gallery
Open your Excel spreadsheet and **highlight the cells** containing the data you want to transpose.
Right-click on the selected cells and choose **Copy**, or press **Ctrl + C** on your keyboard.
Click on the cell where you want the transposed data to begin. Ensure there is enough space for the data to fit.
Right-click on the destination cell, select **Paste Special**, then check the box for **Transpose**. Click **OK**.
Review the pasted data to ensure it has been transposed correctly. Adjust formatting as necessary.