Google Sheets automation for data processing

I am looking for a freelancer to help automate data processing tasks in Google Sheets.

I have data that I need reformatted.
The data is organized by row for each record and columns for record details.
Each record has 9 columns for contact email, name and job title. (Columns ABCDEFGHI)
Each record has 1-3 emails, names and job titles.(Column ABC for contact1, DEF for contact2, GHI for contact3).
I need to reformat the data so each record has only 1 email, name and job title per /record/row.
So a record that has 3 different contacts needs to be separated into 3 rows, with the email, name and title in column ABC.
All of the other record details must remain the same.

See attached video.


The automation process should meet specific requirements and preferences.

The automation needs to run on a daily basis.

Ideal skills and experience for this job include:
- Proficiency in Google Sheets and automation tools
- Strong data manipulation and cleaning skills
- Experience in creating automated processes
- Attention to detail and accuracy in data processing
- Ability to meet daily deadlines for automation tasks.