Forum Discussion
Consolidate quantity of rows with specific results
I am trying to convert the left table to the right table, in this case is TRUE/FALSE but its usually blank or non blank. The point is, to get how many times the specific result applies to each on...
In I2:
=COUNTIFS(Table1[Experimenter],[@Experimenter],Table1[Result 1],TRUE)
In J2:
=COUNTIFS(Table1[Experimenter],[@Experimenter],Table1[Result 2],TRUE)
etc.
