Forum Discussion
Combine files and sheets(from folder)
Hi, Im trying to combine data from a folder with several files and several sheets. Can you help? Each file has a different name Each file has the same 10 different sheets (with different names) ...
wdx223_Daniel
Community Champion
Community Championlet
Source=Folder.Files(YourFolderPath),
Custom1=Table.Combine(List.TransformMany(Source[Content],each Excel.Workbook(_)[Data],(x,y)=>Table.PromoteHeaders(y)))
in
Custom1