@dave have you tried pivot tables? Just guessing, but it sounds like what you want