Hi there

I'm new on the site.

This is an issue re Validation List - multiple choices in one cell. I managed to pick up some codes from the forum and I was able to select multiple choices in one cell and the choices were separated by a comma.

However, when I decided to pivot the table, I found that I couldn't get these choices separated to do a count or to analyse them separately.

I will take any suggestion. Thanks.