select user_id, (case user_dataName when 'X' then USER_DATAVALUE end) as x,(case user_dataName when 'y' then USER_DATAVALUE end) as y,(case user_dataName when 'z' then USER_DATAVALUE end) as z from tableName