Combine data’s from two tables into a third table

I have three tables, and I would like to combine table an and table b data into table c. Is there a way to accomplish this task?

Hi,

Due to uncertainty about your situation, whether you are referring to merging data from two forms into one form or merging data from two tables into one table, I’ll provide guidance for both scenarios:

1.Merging data from two forms into one form: you can consider using Link&Load function.
2.Merging data from two tables into one table: you can consider using Formulas function.

Here, we provide our definitions of form and table. If you need further assistance, please provide more specific details if you require more tailored instructions for your particular scenario.