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 serpiva64
Thanks for your reply. Saw the video. I think the video talks about different column names. In my case, I don't have column names at all. But different number of columns in each file.
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