Excel Slicer Comma Separated Values

I have three columns where column C can contain "multiple" values like "John, Pete" instead of just "John" or "Pete". See table below...

Is it possible in some way to make the slicer for Column C just show the unique values "John", "Pete", "George", instead of the combined ones like "George, John"?



   A                B                 C
Red                 2               John, Pete
Green           3                     Pete
Blue                 4              George, John
Antworne L. SpannSenior Database AdministratorAsked:
Who is Participating?
 
Naresh PatelConnect With a Mentor TraderCommented:
Ok
Step 1 Select whole Column.
Step 2 Select Tab - Data in top of the sheet.
Step 3 Select Text to column, new window will open in sheet.
Step 4 Select separated by comma.
Step 5 next next Finish
Now your text is separated by commas, delete the unwanted text
Thank You
0
 
Naresh PatelTraderCommented:
Step1 Select column C
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.