PIVOT is not going to help you with an already "pivoted" query.
You would have to get the results vertical, then you could apply PIVOT.
Look here for example: http://www.sqlusa.com/
bestpractices2005/crosstabbyvendorbymonth/" target="_blank" rel="nofollow">http://www.sqlusa.com/
Kalman Toth, Database, Data Warehouse and BI Architect
The Best SQL Server 2005 Training in the World