2 Replies Latest reply: Jan 10, 2014 2:29 AM by Bo Adelholm RSS

    Matrix showing combinations

      Hi

      I have a little puzzle.
      I have a table with user and group connections as shown here

       

      GroupUser
      10A
      10B
      10C
      11A
      11C
      12B
      13A
      13B

               

      I need to produce a matrix showing the number of user that has connections to the different combinations groups as
      shown here

          


       

       


       

       

      10


       

       

      11


       

       

      12


       

       

      13


       

       

      10


       

       

      3


       

       

      2


       

       

      1


       

       

      2


       

       

      11


       

       

      2


       

       

      2


       

       

      0


       

       

      1


       

       

      12


       

       

      1


       

       

      0


       

       

      1


       

       

      1


       

       

      13


       

       

      2


       

       

      1


       

       

      1


       

       

      2


       

          

      I recognize that I might have to generate a table like this 

       

      GroupGroup2User
      1010A
      1010B
      1010C
      1011A
      1011C
      1012B
      1013A
      1013B

      (just for the first column)

       

      On the basis of the first table, but how to do it?