I have a column like below
Record | Category
1 ball, bat, stump
2 ball
3 stump
4 gloves, pads
expected output
Record | ball | bat | stump | gloves | pads
1 1 1 1 0 0
2 1 0 0 0 0
3 0 0 1 0 0
4 0 0 0 1 1
Solved! Go to Solution.
@ollieclarke Thank you! It worked like a charm