title: Asp.Net VB or C# how to combine lines & columns based on unique primary field
body: <p>I have been working on a web based report from an existing client/server apps mssql database.  I have a working query, that pulls this information together from many tables, and can provide the query and a result set if necessary.  </p>
  
  <p>The results currently are similar to this.</p>
  
  <pre><code>ID | Name1 | Date1 | Veh  | PO    | Stops
  _________________________________________  
  1  | Bob 1 | 12/1  | Car  | 1234  |  4  
  2  | Sam   | 12/3  | Car2 | 2245  |  3  
  2  | Joe   | 12/4  | Van1 | 5568  |  2  
  3  | Mel   | 1/4   | Van2 | 5678  |  5  
  4  | Mel   | 2/2   | Car  | 3456  |  4  
  4  | Sam   | 2/3   | Bus  | 4565  |  3  
  4  | Joe   | 3/4   | Car  | 6766  |  3 
  </code></pre>
  
  <p>The Problem is that I don't know ahead of time if each ID will have 1 or many lines.  I need the results to return a combined line, concatanate the data from several columns and add another.</p>
  
  <p>Similar to  </p>
  
  <pre><code>ID | Name1         | Date1 | Veh           | PO                |  Stops
  1  | Bob 1         | 12/1  | Car           | 1234              |  4  
  2  | Sam, Joe      | 12/3  | Car2, Van1    | 2245, 5568        |  5  
  3  | Mel           | 1/4   | Van2          | 5678              |  5  
  4  | Mel, Sam, Joe | 2/2   | Car, Bus, Car | 3456, 4565, 6766  |  10  
  </code></pre>