combine two tables in the same worksheet

[Reuben]

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.

[Greg_Deckler · Accepted solution]

If by Merge you mean Append, then use a Folder query.