This worked, I had to add an else and end and it worked like I needed.

SELECT ID,

MAX( CASE WHEN Name = 'Description' THEN Type else null end) AS Description,

MAX( CASE WHEN Name = 'technique ' THEN Type else null end) AS Technique

FROM MyTable

GROUP BY ID

Thanks very much.