Monday, October 22, 2012

Google Spreadsheet formatting the responses from forms

Question:


( 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.

Solution:

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:

=TRANSPOSE('Sheet1'!A:D)

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: http://igoogledrive.blogspot.com/2012/09/donate.html 


Thanks,
Kishan,

3 comments:

  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.

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

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

      Delete