I have cells in Google sheets that have multiple values, such as:
| Continent | Law |
|---|---|
| North America | Sarbanes Oxley, Freedom of Information Act |
| Europe | Digital Markets Act, Digital Services Act |
By default, it groups the items like this in the slicer for the "Law" column:
- Sarbanes Oxley, Freedom of Information Act
- Digital Markets Act, Digital Services Act
I'd like to create a Google docs slicer with each item in the "Law" column individually, such as:
- Sarbanes Oxley
- Freedom of Information Act
- Digital Markets Act
- Digital Services Act
How do I do that? Thanks!

Comments
Nothing yet. Say the first thing.
Sign in to join the conversation.