To easily solve all types of pivoting problems with minimal coding check out the RAC utility for S2k.As easy as Access crosstab query but much more powerful with many features/options.

http://www.rac4sql.net