Results 1 to 3 of 3

Thread: Splitting column data

Threaded View

  1. #1

    Default Splitting column data

    Hello:

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

    Example:

    ACCT_ID, DATE, PRODUCT
    123456789 2018-01-01 BMW,FORD,HONDA
    121212121 2018-01-03 LEXUS
    343435555 2018-03-19 CHEVY,DODGE

    Desired output:

    ACCT_ID DATE PRODUCT
    123456789 2018-01-01 BMW
    123456789 2018-01-01 FORD
    123456789 2018-01-01 HONDA
    121212121 2018-01-03 LEXUS
    343435555 2018-03-19 CHEVY,DODGE



    Thank you
    Last edited by mw9286; 07-08-2018 at 09:57 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •