polzz

SELECT
    Object,
    MAX(CASE WHEN Field = 'foo' THEN Value ELSE NULL END) AS foo,
    MAX(CASE WHEN Field = 'bar' THEN Value ELSE NULL END) AS bar,
    MAX(CASE WHEN Field = 'baz' THEN Value ELSE NULL END) AS baz
FROM table
GROUP BY Object