title: Merging values of a column where ID is duplicated
body: <p>I have a table with an ID column that can contain duplicates, as it's used as a foreign key to match against my main table. There can be multiple results per id, as per the example below:</p>
  
  <pre><code>ID      FieldValue
  1       This
  2       Also this
  1       and that
  3       And additionally, this.
  2       and, finally, this.
  </code></pre>
  
  <p>How would I go about merging the FieldValue column so that there was only one row per ID? E.g.</p>
  
  <pre><code>ID      FieldValue
  1       This;and that
  2       Also this;and, finally, this.
  3       And additionally, this.
  </code></pre>
  
  <p>I wouldn't be concerned if the duplicate rows had to remain, e.g.</p>
  
  <pre><code>ID      FieldValue
  1       This;and that
  2       Also this;and, finally, this.
  1       This;and that
  3       And additionally, this.
  2       Also this;and, finally, this.
  </code></pre>
  
  <p>As I could just run a DISTINCT query on them now that they're truly duplicates. Have been Googling for a while to no results; I suspect because it's something that has a few steps to it and I need to know what those steps are before a search would be fruitful.</p>
  
  <p>Any ideas?</p>