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