Filtering data by answer

I am analysing data from a 34 question survey. I’m using Excel. I want to separate the data in multiple ways, for example one question is “Gender?”: (2 response options: Male, Female) Can I separate the data so I can compare all answers for male participants with all answers for female participants. Similarly another question is “Participation in study group?”: (2 response options: Yes, No). Can I separate so I can compare all answers for those who participated in a study group with all answers for those who did not?

Hi @Peg welcome back!

You can use filter option of excel.

1 Like

You may also use

  • group by for Kobo Report on server level
  • column filter in table view.