Declare @tbl table(MainReq_Reason varchar(25),Cost money)
Insert Into @TBl
select 'Assesories', 5000.00 union all
select 'Electrics' ,9000.00 union all
select 'Heating' ,100.00 union all
select 'Labour' ,2500.00 union all
select 'Others' ,1000.00 

Select 'COST' as AssetCost,* 
from @TBl a
Pivot (Sum(Cost) for MainReq_Reason in (Assesories,Electrics,Heating,Labour,Others)) p

/*
AssetCost Assesories            Electrics             Heating               Labour                Others
------ --------------------- --------------------- --------------------- --------------------- ---------------------
COST   5000.00               9000.00               100.00                2500.00               1000.00
*/