Welcome to the Airtable community!
What you want could be accomplished with two scripts. It is also possible with automations and no scripts.
If you are trying to write the scripts yourself, please post what you have so far and where you are getting stuck.
If you do not want to write the code yourself, are you looking for someone to write the code for free, or do you have budget to hire someone to write the code for you?