You can use grouping to denormalize more efficiently, like so:

SELECT

    MAX(CASE WHEN caption = 'lname' THEN value END) AS lname,

    MAX(CASE WHEN caption = 'charge' THEN value END) AS charge

FROM test

GROUP BY...