Matrix showing combinations

[#1]

Hi

I have a little puzzle.
I have a table with user and group connections as shown here

Group	User
10	A
10	B
10	C
11	A
11	C
12	B
13	A
13	B

I need to produce a matrix showing the number of user that has connections to the different combinations groups as
shown here

	10	11	12	13
10	3	2	1	2
11	2	2	0	1
12	1	0	1	1
13	2	1	1	2

I recognize that I might have to generate a table like this 

Group	Group2	User
10	10	A
10	10	B
10	10	C
10	11	A
10	11	C
10	12	B
10	13	A
10	13	B

(just for the first column)

On the basis of the first table, but how to do it?

[Nicole-Smith · Accepted solution]

How about the attached?

[#3]

Thanks it was exactly
what I were looking for, my problem was that I was building on the existing
table and there creating problems in the other graphs, but using this and
creating a new table made it work.