Here you go!!
DECLARE @t TABLE (Id INT, Score INT)
INSERT INTO @t
SELECT 1,10
UNION ALL
SELECT 1,20
UNION ALL
SELECT 2,5
UNION ALL
SELECT 2,10
SELECT MAX(CASE WHEN t.Perf = 'Excellent' THEN t.Score ELSE NULL END) AS Excellent,
MAX(CASE WHEN t.Perf = 'Good' THEN t.Score ELSE NULL END) AS Good
FROM (
SELECT CASE
WHEN Id = 1 THEN 'Excellent'
WHEN Id = 2 THEN 'Good'
END AS Perf,
SUM(Score ) AS Score
FROM @t
GROUP BY
Id
) AS t