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.
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.
Best Response confirmed by
Benze_ (New Contributor)