Issue with Email Data in Table: Need Help to Resolve Fill Problem

Hey Team! Not sure if this is a bug or just bad data but in this table 'm enriching people for Work Emails but receiving gmail, yahoo, and hotmail addresses. The drawback to this is that it's not filling in the column properly. I'm manually having to go through to see which is the "current_professional" email. I can't just fill the column with Email 1 for instance because Email 1 could be a personal email in another search/enrichment. Maybe there's a formula to fill cells with the sibling of >Email>"current_professional">Address? Thank you! 👻