combine two tables in the same worksheet

Hi all,

I would like to merge two tables that are located in the same excell worksheet (see image below).

I have manged to do in two steps by loading the same file twice and erasing one table, and the combine both queries. But the problem is that I have to do this proccess for >100 files located in the same sharepoint folder.

Any alternative to do this?

Many thanks in advanced.