Google Formula You Need to Know

Are you interested in viewing the data in a Google Spreadsheet in a different format? Keep reading to learn how to transpose the data in a Google Form spreadsheet by adding a simple formula to make the data appear in columns instead of rows.

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:

1. Open an existing Google Form or spreadsheet
2. Click the + on the bottom left to create a new sheet (sheet 2)
3. 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.
4. Press the enter key and watch the data fill the sheet.

Source for this information can be found on Tammy Worcester's blog. Click here to read more.