Sorry under the Stat Column we have different abreviations, for example ACT is active members, Life is life members, and so on, the card number is issued when they pay there dues, so if john was ACT and paid his dues i would issue a card # for example 18751 which to me means paid, if no card is available then that is not paid, so i have a count if statement counting how many members i have per category, so in the below it would say i have 5 LIFE members, but the ones with the card number next to it means they paid, then i have 3 that paid.

Stat Card #
ACT 18751
ASC 18752
LIFE 18753
AFF 18754
LIFE 18755
LIFE 18756
LIFE
LIFE

So i want my report to take the data that i have and place them like this.. 5 is my count, and 3 is how many actually paid...

Thanks in advance!