Data from a Google spreadsheet looks typically like this:
The transpose formula will look like this:
To transpose the data from rows to columns use the following formula:
- Open an existing Google Form or spreadsheet
- Click the + on the bottom left to create a new sheet (sheet 2)
- Enter the following formula in cell A1 in sheet 2: =Transpose(Sheet1!A:H)
- Note: Adjust A:H to the desired range of columns. If you don’t want the timestamp to show, enter B:H.