How to transpose data (rows to columns or columns to rows) in Google Sheets?

To transpose data in Google Sheets from rows to columns or vice versa, follow these steps:

1. Open your Google Sheets document.
2. Select the range of data that you want to transpose.
3. Right-click on the selected range and choose "Copy" from the dropdown menu, or press "Ctrl + C" (or "Command + C" on a Mac) to copy the data.
4. Choose the destination cell where you want the transposed data to start.
5. Right-click on the destination cell and select "Paste Special" or press "Ctrl + Shift + V" (or "Command + Shift + V" on a Mac).
6. In the "Paste Special" dialog box, check the "Transpose" option.
7. Click on the "Paste" button to transpose the data.

Your data will now be transposed from rows to columns or columns to rows, depending on your original data orientation.