Skip to main content

Hello, first of all let me say I'm a newbie so any help is appreciated.

 

I have the following sample data set:

 

SALES REP, SALES ORDER NUMBER

Anthony C, 1234

Johnny P, 5678

Crystal M, 9283

Johnny P, 9283

 

I want to create a matrix that would have the the SALES REP as both column and rows and would list the number of unique SALES ORDER NUMBERs in each box. For the data above, the result should look like this:

 

Anthony CCrystal MJohnny PAnthony C1Crystal M11Johnny P12

 

Anybody has any ideas? I've done a search on the forums but cannot seem to find something similar.

 

Thanks,

 

Jose

2 answers
0/9000