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 can use something that is in that video.
When you get your table with all the table of data
if you expand you hard code the names of columns
So next time you will not get columns if they increase.
Instead if you use Table.Combine you make it dynamic and all columns will be recovered
Click fx
obtain this
then modify it
= Table.Combine( #"Filtered Rows1"[Data])
and it's done
