Let's say 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"?
I would not like to use several rows to define unique values in the slicer for column C. Otherwise I don't care how it can be fixed. New columns with formulas, advanced slicer options or VBA etc? Doesn't matter as long as only one slicer displays unique values....
<tbody>
</tbody>
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"?
I would not like to use several rows to define unique values in the slicer for column C. Otherwise I don't care how it can be fixed. New columns with formulas, advanced slicer options or VBA etc? Doesn't matter as long as only one slicer displays unique values....
Column A | Column B | Column C |
Red | 2 | John, Pete |
Green | 3 | Pete |
Blue | 4 | George, John |
<tbody>
</tbody>