Jen started following Analyzing codes for separate Excel spreadsheet columns
Jen posted a topic in NVivo for MacI have imported an Excel spreadsheet that has an ID column and several additional columns, each of which represents responses to a different open-ended survey question. Rows represent respondents. I have been able to code each cell separately (e.g., Respondent 1's Q1, Respondent 1's Q2, Respondent 2's Q1, Respondent 2's Q2). The coding stripes do not differentiate among columns, however; they show all codes assigned to any of a single respondent's columns. So, for example, how do I filter so that I can analyze only the codes for respondents' answers to Q1 and Q2 and exclude (for the moment) codes from the Q3 and Q4 columns?