select id,pvt.Theatre,Classroom,Boardroom,Banqueting,Cabaret,Dinner,Drinks 
from 
(
	select * from table
) as p
pivot 
(
max(cap) for style in (Theatre,Classroom,Boardroom,Banqueting,Cabaret,Dinner,Drinks )
) as pvt

DECLARE @tablea TABLE (
	[Id] INT
	, [Style] VARCHAR(50)
	, [Cap] INT
	)

INSERT @tablea
      SELECT 468, 'Theatre', 350
UNION SELECT 468, 'Classroom', 160
UNION SELECT 468, 'Boardroom', 50
UNION SELECT 468, 'Banqueting', 230
UNION SELECT 468, 'Cabaret', 150
UNION SELECT 468, 'Dinner', 230
UNION SELECT 468, 'Drinks', 400

SELECT
	[id] AS [Id]
	, SUM(CASE [Style] WHEN 'Theatre' THEN [cap] ELSE 0 END) AS Theater
	, SUM(CASE [Style] WHEN 'Classroom' THEN [cap] ELSE 0 END) AS Classroom
	, SUM(CASE [Style] WHEN 'Boardroom' THEN [cap] ELSE 0 END) AS Boardroom
	, SUM(CASE [Style] WHEN 'Banqueting' THEN [cap] ELSE 0 END) AS Banqueting
	, SUM(CASE [Style] WHEN 'Cabaret' THEN [cap] ELSE 0 END) AS Cabaret
	, SUM(CASE [Style] WHEN 'Dinner' THEN [cap] ELSE 0 END) AS Dinner
	, SUM(CASE [Style] WHEN 'Drinks' THEN [cap] ELSE 0 END) AS Drinks
FROM
	@tablea
GROUP BY
	[Id]