Hi, I want to automatically pull in new report data into one excel masterfile. I receive monthly report and I want to update it to my main excel database. I try using power query to do it , but unable to do it because my monthly report are in an inconsistent format as shown in the pictures. However, the labeling and names are more or less consistent .
ExcelExample3.png
ExcelExample4.png
I am planning to extract the data as shown in the picture into a masterfile. The objective will be that when I recieve a monthly report , all I need to do is to put it in a folder , go to master database and press refresh and it will automatically update it.
Since the labeling and column names are consistent, I am thinking if there is such thing as a vlookup function in power query that allow me to extract the data.
Any suggestion is welcome . Thank you very much.
Attached is some sample files
Bookmarks