Matrix with multiple culomns by multiple colomns

[MyOx]

Hello,

I think i'm trying to do something simple but I cannot find how.

I have data looking like this:

ID	Good1	Good2	Good3	Bad1	Bad2	Bad3
1	x		x			x
2	x	x				x
3			x	x	x
4			x		x
5		x	x		x
6		x		x		x
7	x			x
8	x	x
9				x	x

And I want to show it like that

	Good1	Good2	Good3
Bad1	1	1	1
Bad2	0	1	3
Bad3	2	2	1

Basicly, I want a CountIfs. How many poeple are Bad1 and Good1.

The complexity seams to come by the fact that they can have multiple Good and Bad.

Thanks in advance 🙂

[lbendlin · Accepted solution]

 trying to do something simple 

ahaha. Good one. None of this is simple.

Here's  a version that works but at a high cost - an atrocious data model

see attached.

[lbendlin · Accepted solution]

 trying to do something simple 

ahaha. Good one. None of this is simple.

Here's  a version that works but at a high cost - an atrocious data model

see attached.

[MyOx]

Thanks you. That's what I wanted (I though it was simplier to do though 😅)

[lbendlin · Accepted solution]

Here is a more accurate version that also considers the non-matches.