I need to pull a report from an excel 2007 spreadsheet that has 37 columns?

I am trying to figure out a way to pull a report to summarize the answers submitted in a spreadsheet. Answers vary from yes, no, and n/a their are 37 columns and over 800 rows. Help!!!!!!