I am trying to build a report and I'm a bit stuck. I will try to simplify the example of what I'm trying to do, I wonder if someone may be able to help me.

So I have a table looking like something like this:

ID            Product

1                  A

1                  B

1                  D

2                  B

2                  C

3                  A

4                  A     

4                  C

4                  D

4                  E

So a report would show, for each product, the number of unique IDs that contain other products. Not sure if I'm making any sense, but something like "IDs that contain Product A contain 1 Product B, 1 Product C, 2 Product Ds and 1 Product E"

So the result table may look like: