I have an table that includes entries from a list of tick boxes in 1 cell with each item separated by a pipe. .  See example

This makes adding the total number of any item difficult. Is there any way i can return the individual entries in the end column (advice given) into a filter where i could choose the individual item rather than the entire column of many individual items - which is what i can do just now.

Thanks

Joe