Consolidate quantity of rows with specific results

Highlighted
Frequent Contributor

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 one of the subjects, I would prefer to do this with Power Query, thanks for the help

 

 
GFDFALSETRUEFALSEFALSEFALSE GFD01010
GFDFALSEFALSEFALSETRUEFALSE MBR00220
MBRFALSEFALSEFALSEFALSEFALSE MEG00120
MBRFALSEFALSEFALSETRUEFALSE OOR01101
MBRFALSEFALSETRUETRUEFALSE TFT00120
MBRFALSEFALSETRUEFALSEFALSE VPR00331
MEGFALSEFALSEFALSEFALSEFALSE       
MEGFALSEFALSETRUETRUEFALSE       
MEGFALSEFALSEFALSETRUEFALSE       
OORFALSEFALSEFALSEFALSEFALSE       
OORFALSETRUETRUEFALSETRUE       
TFTFALSEFALSEFALSEFALSEFALSE       
TFTFALSEFALSEFALSETRUEFALSE       
TFTFALSEFALSETRUETRUEFALSE       
VPRFALSEFALSEFALSEFALSEFALSE       
VPRFALSEFALSETRUETRUETRUE       
VPRFALSEFALSETRUETRUEFALSE       
VPRFALSEFALSEFALSETRUEFALSE       
VPRFALSEFALSETRUEFALSEFALSE       
1 Reply
Highlighted

@Ocasio27 

In I2:

=COUNTIFS(Table1[Experimenter],[@Experimenter],Table1[Result 1],TRUE)

In J2:

=COUNTIFS(Table1[Experimenter],[@Experimenter],Table1[Result 2],TRUE)

etc.