:) Read the original message (the very first one) again.
>:) You are bending the necessity to create a use case for "solution". That is a solution for this use case, but not for original question.
>
>>Here is an example of a table and the result I am trying to get. Let me know how I would apply your approach to it:
>>
>>
>>Sample table
>>
>>FIELD1 FIELD2
>>ABC 1
>>CBS 2
>>ABC 1
>>NBC 3
>>NBC 2
>>CBS 0
>>ABC 1
>>NBC 0
>>NBC 0
>>CBS 2
>>CBS 0
>>CBS 3
>>ABC 0
>>XYZ 0
>>NBC 5
>>NBC 5
>>XYZ 0
>>
>>Report Explanation
>>ABC 1 There is only 1 value of ABC (other than 0)
>>CBS 2 There are 2 different values of CBS (other than 0)
>>NBC 3 There are 3 different values of NBC (other than 0)
>>XYZ 0 There are no different value of XYZ (other than 0)
>>
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham