analying s survey form

[reddwarf]

I would like to analyse a survey form.
See attached example.
I am trying to display a total of answers per question and transform that into a grid for easy reporting but am not sure how to do it.
Can someone help?

Thanks

[JBeaucaire]

As long as there is a sequence of numbers in column A like this example that starts at 1 and goes up to the maximum number of entries, this starting formula should work. Put this formula into the first cell of your table, then copy down and across. In this example that would be cell D15:

=COUNTIF(OFFSET($B$3, 1, MATCH($C15, $3:$3, 0)-2, MAX($A:$A), ), D$14)

If there were more data, you would need to edit the two highlighted cell references to the correct starting rows for the new table position. If you move this table to another sheet, it wouldn't need editing if there were more data.

[reddwarf]

Perfect!!
Thanks very much - that is exactly what I needed
Cheers