Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 848
  • Last Modified:

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
0
Antworne L. Spann
Asked:
Antworne L. Spann
  • 2
1 Solution
 
Naresh PatelTraderCommented:
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now