title: How to handle (Google Forms - Spreadsheet) "Checkboxes" answers in SPSS
body: <p>I am analyzing an electronic survey I made using Google Forms and I have the following problem.</p>
  
  <p>One of the questions can take multiple answers in the form of Checkboxes as shown in the picture below. The question is in Greek so I have added some Choice1, Choice2, Choice3 etc next to each answer in order to facilitate my question.</p>
  
  <p><img src="https://i.stack.imgur.com/N9jo0.png" alt="enter image description here"></p>
  
  <p>In my data when someone chose lets say Choice1 and Choice2,
  I will have an answer which is the concatenation of the strings he checked seperated with commas.</p>
  
  <p>In this case it would be: </p>
  
  <blockquote>
    <p>Choice1, Choice2</p>
  </blockquote>
  
  <p>If someone else checked Choice1, Choice2 and Choice4
  his answer in my data would be:</p>
  
  <blockquote>
    <p>Choice1, Choice2, Choice4</p>
  </blockquote>
  
  <p>The problem is SPSS has no way of seperating the substrings (seperated by commas) and understanding which Choices each case has in common. Or maybe there is a way but I don't know it :)</p>
  
  <p>When I, for example, do a simple frequency analysis for this question it produces a table that perceives  </p>
  
  <blockquote>
    <p>Choice1, Choice2</p>
  </blockquote>
  
  <p>as a completely different case from </p>
  
  <blockquote>
    <p>Choice1, Choice2, Choice4</p>
  </blockquote>
  
  <p>Ideally I would like to somehow tell SPSS to count the frequency of each unique Choice (Choice1, Choice2, Choice3 etc etc) rather than each unique combination of those Choices.
  Is that possible? And if it is can you point me to the documentation I need to study to make it happen?</p>
  
  <p>Thx a lot!</p>