I hope you guys can help me out, this should be easy...
I imported the dataset from exel, and now some of the answers that have multiple choices are all packed in one variable. For example
What is your occupation? (more options possible)
So now I my dataset the answers are separated by comma's, all in one column, like this:
resp 1: A
resp 2: A, C
resp 3: C
resp 4: B, C, Other: Z
how can I count the number of A's in all responses?
how can I classify all 'Other' as one category?