Google forms are fabulous for gathering information, but sometimes, the data in the spreadsheet can be difficult to view. In this post, I’ll share a simple-to-implement formula that will make it much easier to deal with (and even print) form-fed data!
The Original Data:
When you collect data into a Google spreadsheet from a form, it will look something like this:
If you have a large amount of questions (and especially if some of them are essay questions), it requires a lot of side-to-side scrolling to view the data.
Transpose Formula to the Rescue!
By using the “Transpose” formula, you can easily make the data look like this:
Notice that the information is now vertical instead of horizontal, making it much easier to view individual responses.
How to do it:
Changes data from rows to columns
- Create a new sheet.
- Enter the following formula in cell A1 of Sheet2:
Note: Adjust A:H to the desired range of columns. If you don’t want the timestamp to show, enter B:H.
- Press the enter key and watch the data fill the sheet!