I want to consolidate rows with matching IDs returning from a SELECT CASE expression. I'm using pgAdmin 3 on a PG-9.3.4 database.

This is what I'm getting on pgAdmin:

And this is what I want to get:

I've tried grouping it, or joining the result to the table itself, but didn't work. Any ideas?

My query code:

SELECT
    CASE
    WHEN t1.material LIKE '%Refuse%'
        THEN t1.disposal
    ELSE NULL
END AS msw_disp,

    CASE
    WHEN t1.material LIKE '%Met%'
        THEN t1.disposal
    ELSE NULL
END AS mgp_disp,

    CASE
    WHEN t1.material LIKE '%Paper%'
        THEN t1.disposal
    ELSE NULL
END AS pap_disp, t1.district

FROM dsny_net t1