Instead of using the PIVOT approach I'd recommend you read the CrossTab article referenced in my signature.

The result of the CrossTab method is similar to the PIVOT approach with one important difference: Once you've understood the concept you can move to the next level: DynamicCrossTab (also linked in my signature). This will allow you to have both, a flexible number of columns and/or variable dates to deal with.

An even better approach would be to leave such data formatting to the application layer (e.g. SSRS) 😉