Forum Discussion
Combine files from folder
Hi I have more than 100 excel files in a Folder which I would like to combine throug Power query. Most of the files have same number of columns (for example 8 columns) except few which have dif...
Hi,
You will find a brilliant solution in this video
Combine Data from Multiple Excel Files with Inconsistent Column Names
by Goodly
If this post is useful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !