Comparison Table to analyze competition

Hey guys,

Have a tough one, I think:

I have in a data table multiple users, each one having multiple lines (one for each residential project that is ok for him). See below:

What I am trying to obtain is a table like this:

Basically a table with rezidential projects and the intersection between them (as percentage, based on user affinity for each project).

And then - step 2:

Build a more user frienly table - something like this:

This way I want to see the competition for each residential project based on the users that are interested in them. 

Thank you for your help