Data360 Analyze

 View Only

  • 1.  Split columns data to multiple rows

    Employee
    Posted 07-29-2021 00:43

    Hello,

    I have a column with multiple values separated by commas that I would like to output to individual rows.

    Example:

    ACCT_ID,  PRODUCT
    123456789  BMW,FORD,HONDA
    121212121  LEXUS
    343435555  CHEVY,DODGE

    Desired output:

    ACCT_ID,  PRODUCT
    123456789  BMW
    123456789  FORD
    123456789  HONDA
    121212121  LEXUS
    343435555  CHEVY 
    343435555  DODGE



    Thank you



  • 2.  RE: Split columns data to multiple rows

    Employee