Conditional merge of two tables

Hi all

I have 2 tables that I would like to merge into 1 but I can't figure out how to do it. The 2 tables below show a simplified snippet of data. Table 1 has values for several parameters (not shown in table) collected every 15 minutes. Table 2 has extra values collected at a random time. I have manually added a column to table 1 [Additional Data] to give a Y at the 15 minute interval that most closely matches the time when that extra sample was collected. I would then like the measurement columns from Table 2 added to the end of Table 1, as shown in the final table.

Is there a way to do this in Power Query? Thank you!

Table 1

Table 2

Desired result