Find multiple "text" criteria and return as ""Yes" in Matrix

Hi,

I have columns that tells me which courses specific people have passed.

I would like this information to result in a matrix for better overview.

Please have a look at the attached file.

Br Bertrand