Solved

Excel Slicer Comma Separated Values

Posted on 2014-02-07
2
619 Views
Last Modified: 2014-02-18
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
Comment
Question by:Antworne L. Spann
  • 2
2 Comments
 
LVL 8

Accepted Solution

by:
itjockey earned 500 total points
ID: 39843437
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
 
LVL 8

Expert Comment

by:itjockey
ID: 39843441
Step1 Select column C
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question