I have a table were the last column can contain multiple comma separated values. See column C in the data table below as an example.
<tbody>
</tbody>
A user would like to filter Column C by unique value e.g. "Guitar", or "Vocals" to return all the rows which have that values. Rather than using an Advanced Filter, is there a way to set up a slicer or use slicer style buttons marked "Guitar" "Drums" "Vocals" "Bass", which when selected would return the rows with those values?
For example:
Thanks!
Column A | Column B | Column C | |
1 | Jimi | jimi@email.com | Vocals, Guitar |
2 | Mitch | mitch@email.com | Drums |
3 | Noel | noel@email.com | Vocals, Bass, Guitar |
<tbody>
</tbody>
A user would like to filter Column C by unique value e.g. "Guitar", or "Vocals" to return all the rows which have that values. Rather than using an Advanced Filter, is there a way to set up a slicer or use slicer style buttons marked "Guitar" "Drums" "Vocals" "Bass", which when selected would return the rows with those values?
For example:
- If I clicked on the button marked Guitar, it would show rows 1 & 3, but filter out row 2.
- If I clicked on the button marked Drums, it would only show row 2.
Thanks!