James96 because you have extra comma in car,ship value, it is like car,ship, if it is car,ship then it will work. It is an issue with data inconsistency.
James96 Based on your question the solution I gave you, should work or I'm not following your question. How far do you go after splitting? Did you use it on the slicer and select car and bike? What Name did you get? Also, how about selecting only car or bike, what names do you get?
