Build email addresses based on existing pattern. - repost

I will provide an Excel file to the winner that contains company names and several contact names for each company (see sample attached). For one same company, some contacts may have an email address while others don’t. I need you to replicate the structure of the email address for all the contacts that don’t have one. For example: Company name: Acme Contact name: John Smith Contact email: john [dot] smith [at] acme [dot] com so this means that all other emails for this company will be based on the structure: name [dot] surname [at] acme [dot] com. If we imagine that for the Acme company we have a contact called Tracy Jones who doesn’t have an email address, then you will build the email address as follows: tracy [dot] jones [at] acme [dot] com. More details to the winner.