Seems, you want to pivot data...
There's 2 ways to achieve that using SQL:
1)
SELECT unit, SUM(CASE WHEN datasource = 'manual' THEN quantity ELSE 0 END) AS manual_quantity,
SUM(CASE WHEN datasource = 'system' THEN quantity ELSE 0 END) AS system_quantity
FROM table1
GROUP BY unit
2)
SELECT unit, [manual], [system]
FROM (
SELECT *
FROM table1
) AS DT
PIVOT(SUM(quantity) FOR datasource IN([manual], [system])) AS pt