year    ID      val

2008	7	NULL
2009	7	0.00
2010	7	0.00
2011	7	0.00
2008	8	NULL
2009	8	0.00
2010	8	0.00
2011	8	0.00

year    7      8
2008   null  null
2009   0.00  0.00
2010   0.00  0.00
2011   0.00  0.00

CREATE TABLE #T3(iYear int, ID int , Val float)

INSERT INTO #T3 VALUES (2008,	7,	NULL)
INSERT INTO #T3 VALUES (2009,	7,	0.0)
INSERT INTO #T3 VALUES (2010,	7,	0.0)
INSERT INTO #T3 VALUES (2011,	7,	0.0)
INSERT INTO #T3 VALUES (2008,	8,	NULL)
INSERT INTO #T3 VALUES (2009,	8,	0.0)
INSERT INTO #T3 VALUES (2010,	8,	0.0)
INSERT INTO #T3 VALUES (2011,	8,	0.0)

select 
iYear, [7], [8] 
from #t3 T
PIVOT (sum(Val) FOR ID IN ([7],[8])) PVT