Count over several columns


I have a table in which in several columns users entered an answer (i.e. for benefits). They named their top four. So I have a column 1, column 2 and column 3 and column4, all with text entries from a pick list. I would like to run a table which gives me an overall count of the individual benefits named. So far I managed the count only per each column, how can I do it so I get a count over all the four columns combined?

I know, probably easy, but I am new to SPSS and couldn't find the answer. Thank you in advance for your reply. Attached is a screenshot of the data table.

Kind regards.



TS Contributor
I am not sure if I understand the problem correctely, but maybe you
could consider the "multpiple responses" analysis. Could be the case
that you have to "automatically recode" the text entries into numerical
codes first.

Just my 2pence

Last edited: