analying s survey form

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