You're probably going to need to use Dynamic Crosstabs[/url], unless each division has exactly the same player names. You'll probably also want to read Cross Tabs and Pivots--Part 1[/url].
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA