Organizing Survey Data

Hello All,

I have a random question re: Organizing Survey Data.

We have been going out and manually surveying about 50 employees per company (for a total of 10 companies). I'm curious as to what you guys think the best way to organize the data in excel would be.

We have 20 questions and a variation of answers for each questions (ex. the answer options are not a standard "1-5 rating"... they vary throughout)

I would like to be able to see how many people dislike A + B about our company, how many people rate us a 5 out of 10 etc.... I'm looking for an easy way to sort the data, or a specific part of the data, as well as the ability to graph the outcome for a specific question.

I'd appreciate any feedback/ideas.

Thank you,

Suzanna