2 Replies Latest reply on Oct 23, 2017 10:25 PM by Galen Busch

    aggregating comma separated values

    Mrinal S

      I have inherited an excel dataset in which a few columns are comma separated values. See example below:

      I am trying to aggregate and viz based of the "Sales Agents" column. Any help on how to best deal with these comma separated values?

       

      Table1 - Sales Orders

      Sale Order
      Sale Agents
      INCV100SA-320, SA-324, SA-40
      INCV101SA-221, SA-230, SA-320, SA-40
      INCV102SA-40
      INCV103SA-345, SA-331, SA-40, SA-100, SA-230

       

      Thanks,

      M