Sorry for the confusion. 1, 2, 3 and 4 are different categorical values of the variables (column) Resp_1, Resp_2, Resp_3 and Resp_4. Resp_1, Resp_2, Resp_3 and Resp_4 are multiple response. I.e. The subject ID 1 responded multiple responses such as 1, 2 and 3 and subject ID 2 responded only 1 which is 2 in column Resp_1. You can think of column value 1=orange, 2=Apple, 3=Graphs, 4=Blackberry. Each subject ID can make max 4 responses, which are written in 4 columns as Resp_1, Resp_2, Resp_3 and Resp_4. I would like to calculate how many respondents preferred 1=orange, 2=Apple, 3=Graphs, 4=Blackberry.
... View more