I'm trying to create a filter menu that allows me to check multiple boxes to search for multiple entries inside a row.
My data looks like the following:
Person | Status
Alice | ABC DEF KLM
Bob | DEF HIJ
Charlie | HIJ
What I would like to be able to do is have a filterable option on Status, to allow you to tick boxes for "ABC", "DEF", "HIJ", "KLM". E.g. selecting HIJ will show both Bob and Charlie, and DEF will show both Alice and Bob, selected ABC and DEF will also show Alice and Bob.
I can't find a way using the filterable method to create the desired outcome.
Any help would be appreciated.