[Solved] T-SQL | SQL-Server Pivot [closed]

Try:

select
    Agent,
    max(case when `desc` = 'Total' then ColValue else 0 end) Total,
    max(case when `desc` = 'Replaced' then ColValue else 0 end) Replaced
from tbl
group by Agent  

Demo sqlfiddle