create a matrix

[jimis]

hi,

would appreciate any advice or suggestions from you clever, clever people....

I need to turn some date in to a matrix to show the number of times various conference rooms have been connected together by videoconference. These conferences can include 2 or more sites at one time.

example of data:

con ID site ID site ID site ID site ID
1 101 303 x x
2 101 202 x x
3 202 404 505 x
4 101 202 303 606
5 505 404 x x
6 404 202 101 x

I need make a matrix (site ID's along side and top) that will indicate the number of time a site has been coneccted to another site. ie:

site101 & site202 =2
site404 & site505 =1
site303 & site404 =0

hope this makes sense and some one can help

[oldchippy]

How about something like this?