title: Trying to combine multiple rows from a table into one row
body: <p>I've been trying to figure this out for a little bit now and i keep running into dead ends.  Maybe someone here can help me.  I work for a company and we are going to be receiving a file for units we are going to repair.  In certain situations, we receive one claim for repair that has multiple units contained within it.  I only have one field to import the serial number and I need to combine how ever many rows there is for a specific claim.</p>
  
  <p>For example the file I would get would look like:</p>
  
  <pre><code>ClaimNumber       SerialNumber
  555                12345
  555                123456
  555                1234567
  556                4321
  557                3421
  558                9876
  558                98765
  </code></pre>
  
  <p>So i need to export this table combining the serial numbers into one field like:</p>
  
  <pre><code>ClaimNumner       SerialNumber
  555                12345, 123456, 1234567
  556                4321
  557                3421
  558                9876, 98765
  </code></pre>
  
  <p>I am limited on receiving the file in this format, so this is all i have to work with.  There are other fields in the file but i think these are the ones that I should be looking at.  let me know if anyone has any ideas.  Thanks!!</p>