title: Concatenate a column in a CSV file
body: <p>I have a CSV file like this:</p>
  
  <pre><code>Computer, App
  PC1, Software1
  PC1, Software2
  PC1, Software3
  PC2, Software1
  PC2, Software4
  PC2, Software5
  </code></pre>
  
  <p>And I want a CSV file like this:</p>
  
  <pre><code>Computer, Apps
  PC1, Software1;Software2;Software3
  PC2, Software1;Software4;Software5
  </code></pre>
  
  <p>I tried using powershell and it almost gets me there:</p>
  
  <pre><code>import-csv input.csv | group-object Computer
  </code></pre>
  
  <p>But it gives me the computer name and a table with the computer name and the apps (which is what I started with)... Any way to break that down further to get at the actual strings?</p>