Please supply DDL and sample data in a digestible format for T-SQL. You'll get a much quicker answer.

One solution, using PIVOT:
CREATE TABLE #Sample (ID VARCHAR(10),
        [Name] VARCHAR(10),
        [Value] VARCHAR(10));
GO
INSERT INTO #Sample
VALUES ('AB12345','Type','beverage'),
   ('AB12345','Unit','6 pack'),
   ('AB12345','Content','beer'),
   ('CD67891','Type','beverage'),
   ('CD67891','Unit','bottle'),
   ('CD67891','Content','wine'),
   ('CD67891','Size','1L');
GO
SELECT *
FROM #Sample

SELECT *
FROM (SELECT ID, [Name], [Value] 
  FROM #Sample) AS Src
PIVOT ( MAX([Value])
   FOR [Name] IN ([Type], [Unit], [Content], [Size])
   ) AS Pvt;

GO
DROP TABLE #Sample