query question

  • Thread starter Thread starter David
  • Start date Start date
D

David

Wondering whether to use a pivot table or a query to take data in this
form
id a b c
1-1 3 2 3
1-2 1 5 2
1-1 3 5 5

and count the number of times each number appears and put it in
another form.

For example id 1-1 has "3" three times so and we'll call that case 2.
It has "2" one time (case1) and "5" two times (case3).
The criterion for case1 is basically how many times equal to "3."
So the output would be as follows for id 1-1:

id case1 case2 case3
1-1 1 3 2

regards, David
 
Why "and we'll call that case 2"? What determines the column the count will
appear under?

What would ID 1-2 look like?
 
Back
Top