Share via

Power Query - importing data from a folder.

Anonymous
2024-08-31T05:51:55+00:00
  • 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?
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2024-08-31T09:05:31+00:00

    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.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-08-31T08:19:44+00:00

    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

    Was this answer helpful?

    0 comments No comments