Matrix or Pivot table or else?

[Sybille]

Hello Forum,

I have to build a "co-location" Matrix and I am wondering if Excel will save me the manual entry…
Here is the context: I have a table of around 2000 rows, with 2 columns.
In the first column, I have adresses, in the second, company names.
In the end, I need to have a crossed table showing which company colocates with the other, whatever the address they sit at.
Note: the number of rows per address may be different from an address to the other, depending on the number of companies they accomodate.

I tried manipulating the data with Pivot tables but I can't seem to catch the thing; and it seems I can't use the company field twice in the same Pivot, in rows and columns.

In short: I'm stuck.

I am including an example of what I have and what I need.

Thank you for your help!