1 Reply Latest reply on Dec 6, 2018 10:53 PM by swaroop.gantela

    Merging values in a table

    Joseph Ong

      Hi all, may I know how to create a calculation for the following please:

       

      Data:

        

      StaffScheme
      JohnA
      JohnB
      MaryC
      PeterC
      PeterD
      PeterE

       

      Expected Outcome:

       

      Schemes
      JohnAB
      MaryC
      PeterCDE