You might also want to check out this link:

http://www.sqlservercentral.com/articles/T-SQL/63681/

How to easily Converting Rows to Columns using Crosstabs

I hope this helps:

SELECT C.Name,

...