create a flow and follow these steps:

1. use connector 'List rows from a table' in Excel Online Business connector to access File 2
2. you will get all data as json. use 'Add rows' connector in same action to add rows to File 1
3. you can customize your result pre-query or post-query using odata filters and filter array actions respectively.