Could try:

SELECT

sapaywk as [Week]

,SUM(CASE WHEN sacoy = 1000 THEN daawrhours ELSE NULL END) AS [Total Hours for Prime]

,SUM(CASE WHEN sacoy = 1000 THEN dahahours ELSE NULL END) AS [Statutory Hours for Prime]

FROM YourTable

GROUP BY sapaywk

Etc.

This is assuming you are defining a brand by the value of column [Sacoy] though.

For example, let's say I have 2 brands called, 'Envy' and 'Lust'. Let's also say I want to find out the total revenue and sales per brand in the same fashion by day in a transaction based table.

SELECT

[Date]

,COUNT(CASE WHEN [Brand] = 'Envy' THEN 1 ELSE NULL END) AS [Envy Total Sales]

,SUM(CASE WHEN [Brand] = 'Envy' THEN [Revenue] ELSE NULL END) AS [Envy Total Revenue]

,COUNT(CASE WHEN [Brand] = 'Lust' THEN 1 ELSE NULL END) AS [Lust Total Sales]

,SUM(CASE WHEN [Brand] = 'Lust' THEN [Revenue] ELSE NULL END) AS [Lust Total Revenue]

FROM MyTable

GROUP BY

[Date]

ORDER BY

[Date]