Forum Discussion

arb1782's avatar
arb1782
Icon for Helper III rankHelper III
5 years ago
Solved

Challenge with split columns by delimiter

Hi   I have data across 6 columns and the data is in two formats depending on the data source. I want to achieve the following:   Category Value Category 1 X, x and x Category 2 Y, y ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

arb1782 Is the data in format 2 all in a single row? If so, could you split by line break? If they are in multiple rows, seems like you wouldn't have to split anything, just unpivot the columns?

  • arb1782's avatar
    arb1782
    Icon for Helper III rankHelper III
    5 years ago

    Hi Greg

    They're in a single row yes. There doesn't appear to be an option to split by line break in the Split columns window. Any ideas?