CREATE TABLE #Food( [Code] [nvarchar](50) NOT NULL, [Group] [nvarchar](100) NULL, [Quantity] [int] NOT NULL, [Color] [nvarchar](50) NULL, ) ON [PRIMARY];

INSERT INTO #Food ( [Code], [Group], [Quantity],[Color] ) VALUES ('Apple', 'Fruit', 44, 'red'), ('Apple', 'Fruit', 1, 'yellow'), ('Pineapple', 'Fruit', 14, 'brown'), ('Apple', 'Fruit', 12, 'red'), ('Banana', 'Fruit', 1, 'yellow'), ('Tomatoes', 'Vegetables', 8, 'red'), ('Cucumbers', 'Vegetables', 3, 'green');

SELECT [Code], [Group], [Quantity],[Color] FROM #Food

SELECT [Group], [Apple], [Pineapple], [Banana], [Tomatoes], [Cucumbers] FROM ( -- (1) SELECT [Code], [Group], [Quantity] FROM #Food ) S pivot ( SUM(Quantity) -- (2) FOR Code in ([Apple], [Pineapple], [Banana], [Tomatoes], [Cucumbers]) -- (3) ) P