0 Replies Latest reply on Oct 9, 2018 8:05 AM by Ben Barber

    Creating a Summary Table

    Ben Barber

      Hi there,

       

      I have a dataset that looks like this:

       

       

       

      Person IDItem ID
      1A
      1B
      1C
      2A
      3A
      3B
      3C
      4B
      5A
      6C
      6C
      6C
      7C
      8B
      8B
      8C
      9B
      9C

       

       

      I want to return something that looks like this:

      Set of ItemsDistinct Number of Persons
      A2
      B1
      C2
      B, C2
      A, B, C2

       

       

      Any ideas on how to do this? Thanks so much!