Query Challenge

Hello Everybody,
I am attaching a picture of what the table should look like before and after the transformation. Can anybody help? Thank you in advance.This is a simple CROSSTAB query. If you look up CROSSTAB in Books Online you will find an excellent explanation and example.|||I'll second Blindman's suggestion! Read up on the Cross-tab reports (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_14_04j7.asp), then come back with questions.

-PatP