Data analysis with multiple data in one cells

Hi all, I have a question on how to do analysis if there is multiple data in one cells (picture below in reject type column). I tried to separate in 2 column but when I insert pivot chart and pivot ...