Consolidate quantity of rows with specific results

[Ocasio27]

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

GFD

FALSE

TRUE

FALSE

FALSE

FALSE

GFD

0

1

0

1

0

GFD

FALSE

FALSE

FALSE

TRUE

FALSE

MBR

0

0

2

2

0

MBR

FALSE

FALSE

FALSE

FALSE

FALSE

MEG

0

0

1

2

0

MBR

FALSE

FALSE

FALSE

TRUE

FALSE

OOR

0

1

1

0

1

MBR

FALSE

FALSE

TRUE

TRUE

FALSE

TFT

0

0

1

2

0

MBR

FALSE

FALSE

TRUE

FALSE

FALSE

VPR

0

0

3

3

1

MEG

FALSE

FALSE

FALSE

FALSE

FALSE

MEG

FALSE

FALSE

TRUE

TRUE

FALSE

MEG

FALSE

FALSE

FALSE

TRUE

FALSE

OOR

FALSE

FALSE

FALSE

FALSE

FALSE

OOR

FALSE

TRUE

TRUE

FALSE

TRUE

TFT

FALSE

FALSE

FALSE

FALSE

FALSE

TFT

FALSE

FALSE

FALSE

TRUE

FALSE

TFT

FALSE

FALSE

TRUE

TRUE

FALSE

VPR

FALSE

FALSE

FALSE

FALSE

FALSE

VPR

FALSE

FALSE

TRUE

TRUE

TRUE

VPR

FALSE

FALSE

TRUE

TRUE

FALSE

VPR

FALSE

FALSE

FALSE

TRUE

FALSE

VPR

FALSE

FALSE

TRUE

FALSE

FALSE

[#2]

@Ocasio27 

In I2:

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

In J2:

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

etc.