Hi, I have tried to pull together 3 separate queries of data, where each group of files contains a slightly different structure.
I don't know how to merge the three queries to combine into a current structure. I've ended up manually matching the structure of the sheets in each file... I assume query can enable me to pull together data from different structures. Please can you help? In the examples for Power Query, there is only a single structure across files, with columns in a common order from my understanding.
thanks, Fran
Not sure that I have understood your intentions, but the attached file contains some queries that connect to a folder containing your three files. It creates a single table containing 460 records. That seems to be the correct number when I look at each individual file.
See if this works for you. Obviously, you have to point the Source to a folder on your own system.
