title: MySQL to CSV - separating multiple values
body: <p>I have downloaded a MySQL table as CSV, which has over thousand entries of the following type:</p>
  
  <pre><code>id,gender,garment-color
  1,male,white
  2,"male,female",black
  3,female,"red,pink"
  </code></pre>
  
  <p>Now, when I am trying to create a chart out of this data, it is taking "male" as one value, and "male,female" as a separate value. </p>
  
  <p>So, for the above example, rather than counting 2 "male", and 3 "female", the chart is showing 3 separate categories ("male", "female", "male,female"), with one count each.</p>
  
  <p>I want the output as follows, for chart to have the correct count:</p>
  
  <pre><code>id,gender,garment-color
  1,male,white
  2,male,black
  2,female,black    
  3,female,red
  3,female,pink
  </code></pre>
  
  <p>The only way I know is to copy the row in MS Excel and adjust the values manually, which is too tedious for 1000+ entries. Is there a better way?</p>