Exceeding query limit when filtering

Within those 1,900 lines there are only say 10 unique values. From the selection made in dropdown1, dropdown2 will then show the next available options and so on.

Here’s a snip of the collection i’m working with…

and the dropdowns:

The idea is to get the user to make a selection which narrows down to the “Groups” field, then a repeater/table will populate based on the “Sizes” within that “Group” field.