I forgot to attach what I was talking about with a pivot table.

DependentDropListTest.xlsx