Power Query - importing data from a folder.

Question

• When I have a single file in the folder the query output results in a table with four columns as expected.
• My column results are: Issue, Webpages Searched, Advice and Legislation
• When there is more than a single file in the folder, I end up with all of the columns result above and then new columns are added for the data from the second file.
• The new columns are titled: Issue_1, Webpages searched_2, Advice_3, Legislation_4.
• Instead of recognising that column headers are the same in the second file and, therefore, the content from the second file should be included as a second row, it is creating additional columns.
• Any thoughts for me?

Answer 1

Makes no sense for me, IMHO there is something wrong in your main import query.

Zip a bunch of the files to import and your main file, upload to an online file holster of your choice and post the download link here.

Andreas.

Answer 2

Are many attempts I have come up with a workaround each excel file in my folder has been set up with a query on the second sheet, my total query importing all the files now gathers the data from that second sheet. An extra step but it works and that will do