Power Query Editor.

[Benze_]

Hi all, First of all, I am new in this group-Somebody should welcome me!!! Otherwise, I'm seeking help on how to merge/combine over 3 files in power query editor. Whenever I get to the "get data from folder" option, the first file automatically gets selected(or sometimes I only have one option to select of all the 3 files), making difficult to combine all the files.

Please, I need your help.

Thanks.

[#2 · Accepted solution]

@Benze_ Welcome in this nuthouse!! :)

Once you have the preview of the list of files, make sure you click "Transform data". Then you should get a list of all files. Filter that list so you end up with exactly the files you want to combine.

[#3]

Thank you so much.