Monday, October 22, 2012

Google Spreadsheet formatting the responses from forms


( by Catherine Humberger )

The results spreadsheet inserts my questions in columns and the responses in rows. I would like the questions in rows. How can I change this? Thanks in advance.


Suppose if you are getting the responses from a form in a sheet named 'Sheet1', have a look at the screenshot of the example spreadsheet's 'Sheet1':

Now to change the format of the data, make a new sheet let's name it 'Sheet2'. In 'Sheet2' put the following formula in Cell A1:


The above formula will give you the output as the following:

So now you have the data organised as having responses in columns instead of rows, and you will be having questions in first Column instead of first row.

Note: In the formula I have used the sheet name as 'Sheet1' which you need to change according to your sheet name and also you need to change the range as per your requirement.

I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.

I also take up private or confidential projects:

If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: 



  1. thanks...helped a lot.
    I was trying to do this manually and got about 10 minutes in before I wondered if there were an automatic way to do it. Big help.

  2. I would love to just transpose my form results in another sheet, but when I use this formula, all I get is #REF!

    1. Hi, I would suggest you to share your spreadsheet with me...
      My email id is kishan.pionero (at) gmail . com