Power Query - Is it possible to append tables with overlapping data

Hi,

I am new to this community and was hoping to get some guidance around tackling an situation I am facing.

I receive a data in a table format for last 100days every week. I would like to append the tables and create one table from all the files however, I cannot think of a way to active this using power query.

I have created rolling 14day data table below as an example.

Table 1

The next week I would receive a table like below

So I would like to append the two tables and create a table which contains data for 1-21 Jan, but avoid duplicating 07-14 Jan data, is this possible using power query?

Thanks in advance.