1 Reply Latest reply on Nov 16, 2018 5:01 AM by Norbert Maijoor

    Splitting chain of characters separated by delimiter into rows

    Charlotte Bantegnie

      Hello everyone,

       

      I am looking for an easy solution to split a table like this:

       

       

      Initial Table

       

      Missing product

      Product price

      Preparing shops

      1/2/3/4/5

      1,1€ /1,3€/23€/15€/16€

      Shop 1

      3/6

      2,1€/3,5€

      Shop 2

       

      Revised table

       

      • Utilisation d’une fonction fractionner par ligne

       

      Missing product

      Product price

      Preparing shops

      1

      1,1 €

      Shop 1

      2

      1,3 €

      Shop 1

      3

      23 €

      Shop 1

      4

      15 €

      Shop 1

      5

      16 €

      Shop 1

      3

      2,1 €

      Shop 2

      6

      3,5 €

      Shop 2

       

       

      Thanks a lot for your help !

       

      Best regards,

      Charlotte