Welcome to the community, @Lisa_Tabb!
You can do that post-submission with an Airtable automation. You would collect the form answers into a single table, and then you would use an automation to move values into the appropriate places.
You can also automate this with an external tool like Integromat, which adds lots of extra features & functionality (such as conditionals).
And, you can also use a tool like this one:
