I'm doing some basic survey analysis. I want to break down responses to various questions based on Male or Female. Each row is a response, each column is a question. Column A has the Male/Female response that I want to sum all other responses against. Each other column has various responses to that question. Different columns have different sets of possible responses, though some have the same. There are some empty cells that I would like to count as such.
I figured out how to do it for a single column with DataPilot. But as soon as I add more than one column into DataPilot, it gets messy.
If I could generate the equivalent of a table like this, that would be what I want:
Male Female Q1 Yes 1 1 No 0 1 Maybe 1 0 Q2 1 Hr 2 1 2 Hr 0 1
Is there a straightforward way to do that?
Input data for the above would be:
Respondent Gender Q1 Q2 Respondent1 M Yes 1 Hr Respondent2 M Maybe 1 Hr Respondent3 F Yes 1 Hr Respondent4 F No 2 Hr