You didn't need to open a new thread. You could just post this on the previous one.

Here's an example, but don't blame me if it doesn't work as you want because you continue to avoid our advices.

SELECT Time,

SUM( CASE WHEN DayOfWeek = 'Monday' THEN CallsOffered END) AS Monday,

SUM( CASE WHEN DayOfWeek = 'Tuesday' THEN CallsOffered END) AS Tuesday

FROM SomeTable

GROUP BY Time