People,

I'm from Brazil, so my english is not that great!!

I've tried to find a answer to my question with the search tool, but i found nothing (maybe cause i don't know how to say what i want to say!! ).

The thing is:

I want to creat a table with the count of coincidents values. I have a list of Whosalers and Stores, and i need a table whith de whosales on columns and rows, but the values is the count of stores the combination of columns and rows.

Something like this:

File:

Whosaler Store
1 A
1 B
1 C
1 D
2 F
2 B
3 A
3 C
3 F
4 C
4 F
4 G
4 H

And i want to make a table like this:

1 2 3 4
1 4 1 2 1
2 1 2 1 1
3 2 1 3 2
4 1 1 2 4

Where the first row and columns are de whosale number, and the values in the tables are the count of store, so i can say "i have 2 stores that wholesaler 1 an 3 works together".

After that i will be able to do a chart whith de intersections, analysing the way the market are suplied.

I hope someone can understand me, and that person who understood can anwer me!!!

Thanks everyone!

Rafael