I am trying to consolidate a few files with the same structure inside a folder using power query. My problem is that the structure of the files is a little bit weird and I cannot for a few days already can't figure out how to complete the query.
The structure of the files are on Sheet1 and the expected output is on Sheet2 on the fgi
Sample
The structure of the files are on Sheet1 and the expected output is on Sheet2 on the fgi
Sample