I have just recently finished inputting data into a spreadsheet which is a whole bunch of survey responses and I am trying to figure out the best way of now “analysing” it. Unfortunately the questionnaire consists of various types of questions, including some open ended, some where the participant selected a number on a scale, or the participants could select any number of options (e.g. tick any that apply).
From a brief search, I see that you can’t have two headings as such for a pivot table so I am wondering what the best approach might be. I have attached a sample spreadsheet with some of the questions if it helps. I have a hunch though that it’s going to be a matter of analysing each question individually and using filters and countif formulas (see attached).
Your input would be appreciated before I jump in and start doing everything manually :smile: .