Forum Discussion
Merging Data with same column header but different column orders.
Hi everyone, been struggling figuring out why would power query not combine headers with the same name from multiple excel files. The orders of columns is not the same, but I thought power query combines based on header name? TYA!
Hi, ickest ;
You could refer to those video.
https://www.youtube.com/watch?v=wKglApDFMog
https://www.youtube.com/watch?v=sb0hmwiFM-E
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
ickest , You trying merge or append?
I think append is one you want to try and is that giving this issue?
I'm trying to append all excel files from a folder (source is folder).
Hi, ickest ;
You could refer to those video.
https://www.youtube.com/watch?v=wKglApDFMog
https://www.youtube.com/watch?v=sb0hmwiFM-E
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
