1 2 Previous Next 15 Replies Latest reply on Aug 13, 2018 5:52 AM by Adi Nalla

    Data Split into 2 rows

    Adi Nalla

      Hello all,

       

      I have a dataset that looks something like below

      CasePerson
      AA-23426Tom
      BB-45643David and Jared
      CC-07897Watson

       

      Is there anyway I can change it to

      CasePerson
      AA-23426Tom
      BB-45643David
      BB-45643Jared
      CC-07897Watson

       

      I know I can do it with Pivot option, but I am not using excel/file type datasource here. I can able to split them using 'custom split' but that gives me 'person' names in separate columns instead of separate rows.

      Is there any way or calculated field we can use to achieve this?

      Thanks in Advance.

        1 2 Previous Next