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

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?

Route Count.yxmd