Making a matrix out of a master data table

Hi All,

Please see the spreadsheet attached.

I need to create a matrix which compares the suppliers that three organisations work with to see if there are any duplicates (i.e. where org 1 an org 2 share supplier 2).

Tab 1 (Master) is the raw data showing suppliers, Tab 2 is the matrix I need creating and Tab 3 is the result I would like, it shows in a matrix where the organisations share the same supplier - I can do this manually but this will take a lot of time (there are thousands of rows of data with the spreadsheet i'm working on).

As you can see in Tab 1 by reading down the first column organisations share the same supplier (all organisations work with supplier 2).

Is there a formula at all that will automatically create this matrix in Tab 2/3?

Many thanks in advance!!
Alex

Special-K, brill, thank you very much! Near formula