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?