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
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