One Filter with Values from Multiple Columns

Hi,

Can the filter options either use values from multiple columns or break up values from one column into multiple drop-down options?

Example: a table with programs for children with a column for ages. However, the age ranges for different programs overlap (e.g. 6 – 10, 8 – 12, etc.). One way or another I’d like one filter with unique age ranges as the options (e.g. 6 – 8, 9 – 12, etc.). These unique age ranges could come from multiple columns or one hidden column with multiple values per field delimited by a character.

Thanks