title: Copy and modify a row in csv file
body: <p>I need some help with a csv file. I'm working with the CIS Automotive API and am extracting data to put in a database. I turned the data into a csv file, however there are some rows with multiple ID's. Is there anyway I can copy the row but with one ID each?</p>
  <p>The csv file is like this at the moment:</p>
  <pre><code>Dealership     | Address       |Zipcode| DealerID
  Charleston Kia | 123 Bowman rd | 29412 | 12345,21456,32145
  </code></pre>
  <p>and I wanted to make it to look like this:</p>
  <pre><code>Dealership     | Address       |Zipcode| DealerID
  Charleston Kia | 123 Bowman rd | 29412 | 12345
  Charleston Kia | 123 Bowman rd | 29412 | 21456
  Charleston Kia | 123 Bowman rd | 29412 | 32145
  </code></pre>