Luis Cazares (8/15/2016)

---

You can use a method called cross tabs (or the pivot operator) which is explained in here:

http://www.sqlservercentral.com/articles/T-SQL/63681/

Here's an example based on your greatly posted sample data.

SELECT ComputerID,

MAX(CASE WHEN TypeDescription = 'Ram' THEN TypeValue ELSE '' END) AS Ram,

MAX(CASE WHEN TypeDescription = 'Hdd' THEN TypeValue ELSE '' END) AS HDD

FROM dbo.tblTypes

GROUP BY ComputerID;