title: SQL Concatenating row values on primary key
body: <p>I have a requirement to concatenate values in different rows of my query based on Item ID. </p>
  
  <p>For instance, I have the following rows of data. </p>
  
  <pre><code>GroupID LABEL   VALUE   UNIT
      1   Name    Henry   
      1   Guest   Manny   Guest
      1   Room    12  
      1   Milk    10      Quart
      1   Eggs    3       dozen
      2   Name    Mark    Supervisor
      2   Water   13      Litre
      2   Milk    3       Gallons
      2   Soap    12      bars
  </code></pre>
  
  <p>And as output, I want to get the following </p>
  
  <pre><code>ItemID     VALUE 
  
  1          Name: Henry; Guest:Manny Guest; Room:12; Milk:10 Quart; Eggs: 3 dozen;
  
  2          Name: Mark supervisor; Water: 13 litre; Milk: 3 Gallons; Soap: 12 bars;
  </code></pre>
  
  <p>How do I accomplish this please? </p>