title: Combine multiple rows with the same ID field into one row, by adding the neccessary columns
body: <p>Below is what I am working with that is already stored in a table</p>
  
  <pre><code>ParentID   ComputerName ProductCode
  --------   ------------    ------------
  117   AZ18LTDJBN2R1 EEADMIN_1000
  117   AZ18LTDJBN2R1 EEGO____1000
  117   AZ18LTDJBN2R1 EEPC
  117   AZ18LTDJBN2R1 EPOAGENT3000
  117   AZ18LTDJBN2R1 HOSTIPS_8000
  117   AZ18LTDJBN2R1 PCR_____1000
  117   AZ18LTDJBN2R1 SITEADV_3500
  117   AZ18LTDJBN2R1 SUPPCLNT1000
  117   AZ18LTDJBN2R1 VIRUSCAN8800
  </code></pre>
  
  <p>How can I merge this 9 rows into 1 row with added columns for each record/productcode?</p>
  
  <pre><code>ParentID   ComputerName EEADMIN        EEGO            EEPC    EPOAgent        etc.   
  --------   ------------    ------------  -------------   ------   ----------     ------
   117      AZ18LTDJBN2R1 EEADMIN_1000  EEGO____1000    EEPC     EPOAGENT3000    etc. 
  </code></pre>
  
  <p>Any assistance will be greatly appreciated. Thanks.</p>