Hi, I'm trying to filter some data that is basically in two columns, a string and a value, for e.g.:

A 1
B 2
C 3

The problem is, C is a supergroup that actually means A & B, but they both have the same value. Rather than maintaining duplicate rows for A & B every time there is a C, I was wondering if it is possible to have a filter such that when A is selected, it will show values for both A & C, ideally without using VBA.

Does anyone have any ideas?