Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,886 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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!