Comparing Records between two fields

[nfoong]

Hi,

I have the following sample and would like to convert it to the next table below, which shows that if the 2 routes have the same supplier, show the number of common suppliers between both routes. Hope that makes sense.

Thanks.

Supplier	Routes
A	Route 1
B	Route 2
B	Route 3
C	Route 2
C	Route 3
D	Route 4
E	Route 1

	Route 1	Route 2	Route 3	Route 4
Route 1	x
Route 2		x	1
Route 3		1	x
Route 4				x

[Joe_Mako · Accepted solution]

How about something like the attached?

Also what is the logic to get 1 instead of 2 for the the number of suppliers with both Routes 2 and 3?

[skalgaonkar]

I realize this is a few years later, but I was recently looking to resolve a similar issue and your solution helped.  Thank you!