title: SELECT distinct values for multiple rows of same ID
body: <p>I have a table that looks like this:</p>
  
  <pre><code>ID | FIELD_NAME   | VALUE
  23 |  sign_up     |  yes
  23 |  first_name  |  Fred
  23 |  street      |  Barber Lane
  24 |  sign_up     |  no
  24 |  first_name  |  Steve
  24 |  street      |  Camaro St.
  25 |  sign_up     |  yes
  25 |  first_name  |  Larry
  25 |  street      |  Huckleberry Ave
  </code></pre>
  
  <p>I want to run a query that will select unique ID's and the values as named columns so it would appear like so:</p>
  
  <pre><code>ID   |   SIGN_UP   | FIRST_NAME  |  STREET           |
  23   |     yes     |    Fred     |  Barber Lane      |
  24   |     no      |    Steve    |  Camaro St.       |
  25   |     yes     |    Larry    |  Huckleberry Ave. |
  </code></pre>
  
  <p>Any help would be much appreciated!!</p>