title: SQL duplicate values in multiple columns
body: <p>I have a table with duplicate ID's, but other values in the second column.
  Instead of removing all the duplicates with DISTINCT, I need 1 row with the ID and several columns with the values from the second column.</p>
  
  <p>Here is what I mean: (has to become result)</p>
  
  <p><img src="https://i.stack.imgur.com/4z4nF.jpg" alt="Original"></p>
  
  <p><img src="https://i.stack.imgur.com/3a6Jn.jpg" alt="Result"></p>