title: Pivot Table Omitting Rows that Have Null values
body: <p>I am solving a problem very similar to <a href="https://stackoverflow.com/questions/7674786/mysql-pivot-table">this</a> only in my case, I am not summing any values.
  <br />
  I have been able to write a select that works using solution from <a href="http://www.artfulsoftware.com/infotree/qrytip.php?id=78" rel="nofollow noreferrer">this page</a></p>
  
  <pre><code>SELECT 
    id, 
    GROUP_CONCAT(if(colID = 1, value, NULL)) AS 'First Name',
    GROUP_CONCAT(if(colID = 2, value, NULL)) AS 'Last Name',
    GROUP_CONCAT(if(colID = 3, value, NULL)) AS 'Job Title'
  FROM tbl
  GROUP BY id;
  </code></pre>
  
  <p>However, I want to omit rows that have the <code>value</code> to be null</p>