3 Replies Latest reply: Nov 23, 2014 8:50 PM by jagan mohan rao appala RSS

    Cleave values in one row on two  rows

    Benjamin Bueder

      Hi everybody,

      I've an Excel file which datas contains  severals values in one row separated with a coma, like that:

       

       

      Account Name          Account Responsible          BI Tools

      Customer1                   AR1                                BO,BW

      Customer2                    AR2                               QlikView,BO

      Customer3                    AR3                               Microsoft BI

      Customer4                    AR4                               Tableau

       

      I want to write a script to get a table like the sample below:

      Account Name          Account Responsible          BI Tools

      Customer1                   AR1                                BO

      Customer1                    AR1                               BW

      Customer2                    AR2                               QlikView

      Customer2                    AR2                                BO

      Customer3                    AR3                               Microsoft BI

      Customer4                    AR4                               Tableau

       

      Could someone help me please?

       

      Thank you