Forum Discussion
How to format: Row has more than one value for a column (parameter)
Newbie here. I am looking for the right keywords or a solution or concept for the following problem: Context: I want to analyze Spotify data. For this I have the artists with their respective IDs...
Anonymous I'm not quite sure what you are doing but what I would do is split the genre column on "," and then unpivot the resulting columns. Then the problem is pretty trivial.
Greg_Deckler
Community Champion
Community ChampionAnonymous I'm not quite sure what you are doing but what I would do is split the genre column on "," and then unpivot the resulting columns. Then the problem is pretty trivial.
Greg_Deckler Thank you! This works perfectly!