( by Catherine Humberger )
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.