I have data (40000+ rows) that is in format like (including empty rows)

I want to get list of ‘all’ Model where Model Type = Interest and corresponding Marge (sometimes after 2 rows and sometimes after 3 rows) = Yes
So in this example it should return A, D

Tried lots of combination of Filter, XMatch etc. Any suggestions.