title: Concatenate 2 values from the same column with different conditions
body: <p>I am trying to concatenate 2 values from the same column but with different conditions. here is my sample table.</p>
  
  <pre><code> ----------------------------------
  | user_id | key        | value     |
   ----------------------------------
    1         firstname    maria
    1         lastname     enuole
    2         firstname    chris
    2         lastname     magnolia
  </code></pre>
  
  <p>concatenating values from the value field with key firstname and lastname with the same user_id. Sorry its really hard to explain.</p>
  
  <p>i would like a result like this...</p>
  
  <pre><code> --------------------------
  | user_id | Name           |
   --------------------------
    1         maria enuole
    2         chris magnolia
  </code></pre>
  
  <p>Is there a way to do this? Thanks for the feedback.</p>