Option 1: Use Pivot as 0x01AA suggested.
Option 2: Use JOINS against the same table to slice the data the way you want it.
Based on what you have provided, the below should work.
SELECT
a.Resources,
COALESCE(SUM(CONVERT(INT, d.duration*6.25)), 0) AS Technical,
COALESCE(SUM(b.image_count), 0) + (COALESCE(SUM(c.image_Count), 0)/4) AS DataEntry,
COALESCE(SUM(CONVERT(INT, d.duration*6.25)), 0) + COALESCE(SUM(b.image_count), 0) +
(COALESCE(SUM(c.image_Count), 0)/4) AS Total
FROM
work a
LEFT JOIN work d ON a.resources = d.resources AND d.scope = 'Technical' AND YEAR(d.dat_e) = '2016' AND MONTH(d.dat_e) = '7'
LEFT JOIN work b ON a.resources = b.resources AND b.scope = 'DataEntry' AND b.work_area = 'Coding' AND YEAR(b.dat_e) = '2016' AND MONTH(b.dat_e) = '7'
LEFT JOIN work c ON a.resources = c.resources AND c.scope = 'Technical' AND c._work_area = 'QC' AND YEAR(c.dat_e) = '2016' AND MONTH(c.dat_e) = '7'
GROUP BY
a.Resources
Kind Regards