title: Collecting comma separated data in a single cell
body: <p>I have an excel table which stores results from a questionnaire. It includes a column where the responder includes multiple responses. I want to treat each response as a separate data point:</p>
  
  <pre><code>Favourite Colour | Age |
  -------------------------
  Blue, Black      | 12  |
  Red, Green, Blue | 11  |
  Orange           | 12  |
  Black, Blue, Red | 13  |
  Red, Black       | 11  |
  ...
  </code></pre>
  
  <p>Which would return:</p>
  
  <pre><code>Blue: 3
  Black: 3
  Red: 3
  Green: 1
  Orange: 1
  </code></pre>
  
  <p>Even better:</p>
  
  <pre><code>12 - Black: 1
     - Blue:  1
     - Orange:1
  11 - Red:   2
     - Green: 1
  ...
  </code></pre>
  
  <p>And I would hopefully be able to put this in a graph.</p>
  
  <p>I've done some reading online and come across a <code>LookUp</code> command or <code>LookUpV</code> but am not sure about them so I though I would post a question.</p>
  
  <p>Hopefully I made my point clear enough.</p>