Count unique combination of columns

[Derek-]

Hi there,

We have this table

id	A	B	C	D
111	1	0	0	1
222	1	1	0	1
333	1	1	1	0
444	0	1	0	1

We're trying to count the overlapped columns to get this output:

For example: the A to B = 2 *.

IDs 222 and 333 have both A and B products, hence it's 2.

And no one has C and D, hence zero, *.

	A	B	C	D
A	---	2 *	1	2
B	---	---	1	2
C	---	---	---	0*
D	---	---	---	---

Thanks for your help!

[benakesh · Accepted solution]

Hi @Derek- ,

Transpose and  summarize  produces the expected output. 

[Derek-]

Thanks so much! Appreciate it!