Cleaning a database with a list

Hello,
I am currently simplifying a database, which has the following format. Consider that each line is the description of a bank transfer for electoral funding (public data). Each candidate can have dozens of funding sources, resulting in dozens of lines.

election code; data; time; contract; candidate, transfer, amount; funder
133; ............................................ John; 77987; $800; Big Company
133; ............................................ John; 79619; $1900; Huge Company
133; ............................................ Mark; 87681; $300; Small Company
(I put these unnecessary variables, like election code, at the beginning, as in the file)

I have 130,000 lines like this, because the database is about candidates, whether elected or not. But Mark was not elected! So I have 90% of unnecessary people in the database, and obviously, the creator of the database did not think to include an "elected" variable.

However,
I have another database with 550 names: those elected.

Is there an automatic process, or VBA (I am so bad at VBA…) to clean up the list?
I would like to delete all the lines where the CANDIDATE is a name that does not appear in the other list. Do you see what I mean?

Thank you very much for your help,