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:

http://igoogledrive.blogspot.in/p/paid-projects.html

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,

iGoogleDrive