This post derives from following - 
https://dba.stackexchange.com/questions/77997/select-multiple-values-from-same-column-one-sql-statment/101952#101952

Based on this query - 

     SELECT user_id,GROUP_CONCAT(meta_value ORDER BY id) 
     FROM t 
     WHERE meta_key  IN('first_name','last_name','street_add','city','state') 
     GROUP BY user_id

It will give me a comma separated column, which is great and gives me the data, but is there a way to separate the fields into columns?