You can use cross tabs to accomplish this. To read more about this technique, read the following article.
http://www.sqlservercentral.com/articles/T-SQL/63681/
SELECT ID,
MAX( CASE WHEN Name = 'Description' THEN Type) AS Description,
MAX( CASE WHEN Name = 'technique ' THEN Type) AS Technique
FROM MyTable
GROUP BY ID