How to split two stacked blocks of data using repeated identifiers in Power Query Editor.

Question

I am trying to aggregate multiple Excel files using power query editor but the files have two stacked tables with different data for the same samples (first picture). In power query editor I'm having trouble figuring out how to tell it to create new columns for the lower table, and if the lot number for the row matches, copy the lower table test result inline with the top table. Then I can delete the bottom table and have all the test results in a single row for that lot (second picture).

Thanks!