nevermind...

Are you looking for a crosstab? I'm just not very clear on your requirements.