CREATE TABLE [dbo].[gotilla](
[ID] [int] NULL,
[Category] [varchar](50) NULL,
[Weekof] [varchar](50) NULL,
[Total_hur] [int] NULL
)
select category ,id,Sum(case when weekof='7/2/2012'then total_hur end)as '7/2/2012',
SUM(case when weekof='7/16/2012'then total_hur end)as '7/16/2012',
SUM(case when weekof='7/9/2012'then total_hur end)as '7/9/2012'
from gotilla
group by category,id