Matrix: Identify cell content in column for a row if matrix content true

Hi,

For a table like the one below produced for the sake of example (actual is much much bigger) I want to make it list rows that are true for a certain column for a certain variable in the matrix. So for say water terrain, which types of activity can I do i.e. swimming. Or for Offroad the activites which I can't do i.e. Run and Swim.


Activity Water Road Offroad
Jog n y m
Run n y n
Walk n y y
Swim y n n

y=yes
n=no
m=maybe

Can this be done? Appeciate your help.

Many thanks,

T