Data matrix - joining/simplifying variants

Hello,

I have a huge data matrix - total 9500 rows.

I have a versions defined with a key - see attachment

Each mark in variant has a different meaning. It could mean color, weight, length,...

From that data matrix is made.

And now I am looking for reverse functionality. If I want to find all variants that consist with color black - see attachment.

Hope my case is clear.

Thank you in advance.

Best regards,

J