title: Reshape SQL date
body: <p>following problem</p>
  
  <p>I am using the command to join Names with project numbers</p>
  
  <pre><code>SELECT DDR_namen.vorname_nachname, DDR_Erfinder_final.pubnr
  FROM DDR_namen
  RIGHT JOIN DDR_Erfinder_final
  ON DDR_namen.vorname_nachname=DDR_Erfinder_final.vorname_nachname
  </code></pre>
  
  <p>which gives me someting like this (small example)</p>
  
  <pre><code>vorname_nachname  Pubnr (ID)
  A. Heinrich       100
  B. Müller         100
  B. Müller         101
  B. Müller         105
  C. Krüger         120
  C. Krüger         100
  </code></pre>
  
  <p>Now I want to reshape the data, so that the rows are unique and the ID are combined into a new collumn. Like this.</p>
  
  <pre><code>vorname_nachname  Pubnr (ID)
  A. Heinrich       100
  B. Müller         100;101;105
  C. Krüger         120;100
  </code></pre>
  
  <p>Anybody and ideas?</p>