Maybe you can use this technique from Debra Dalgleish's site:
http://contextures.com/xlForm01.html

I'd add a name field to each of the rows. Then you could copy the Name,
question number, and response from each person's worksheet and create a giant
workshet with all the results for all the people.

Then you can do your sorts, filters, pivottables, charts, ...

Maddie1020 wrote:

Hi

I have been given a task to gather questionnaire data for a school, with 12
questions and 5 possible answers. I am likely to get hundreds of responses.

I have tried to set up a survey without much success and am wondering the
easiest way to do this. Is there a template I can download to help me?

Many thanks

Maddie

--

Dave Peterson