Trying to find the most common wrong question.

I need to be able to determine which question is most frequently missed. Issue is that the format it comes in is not easy conducive to determine that. I don't know if there is a way to determine that with a macro. Right now it looks like this

1. Question
yes - # - %
No - # - %
N/A - # - %
Total - # - %
2. Question
yes - # - %
No - # - %
N/A - # - %
Total - # - %

Something as simple as a table with the left column being the question #, second column being yes#, third being no# and fourth being N/A%. Like this maybe?

# - Yes - No - N/A
1 - 3 - 0 - 0
2 - 1- 1- 1