I have a dataset like this -
I want an output like this -
ID Category Christianity Religion & Spirituality Christianity History True Crime Society & Culture True Crime Documentary
Using “substr($Cat$, 0, (length($Cat$)-1))” in String Manipulation, I am able to remove the last comma from the data.
I tried to do UNGROUP on the category column, but, it doesn’t work.
Any help is highly appreciated.