4 Replies Latest reply on Oct 9, 2018 12:02 AM by seraj alam

    Split and combine the data in one column

    sagar a

      Hello Team,

       

      I have got a requirement regarding the data in different columns and to split the data and add to the single column like below sample data.

       

         

      DateRecordingsValues
      5/30,7/5,3/1556,45,76M1,M2,M3

      4/13,9/25

      5.17,7/25,6/30,10/25

      67,89

      56,78,98,23

      M1, M2

      M1,M2,M3

       

      Now I need to combine the data like below

       

      New values

      5/30,56,M1

      7/5,45,M2

      3/15,76,M3

      It could be the great help for me.