7 Replies Latest reply: Apr 27, 2017 7:17 PM by Rob Wunderlich RSS

    Sorting data in semi colon format

    m m

      I have 2 fields with data.

       

      KeyItemTypeCost
      123BAX12
      124PPP88
      123AAC43
      126ITF65
      124ZAY15
      126QVM43
      123AQV87

       

       

      I want 2 strings of data seperated by semicolon that match ItemType & Cost group by Key.

       

      Results Required:

      KeyItemTypeCombinedCostCombined
      123BAX,AAC,AQV12,43,87
      124PPP,ZAY88,15
      126ITF,QVM65,43