SOLVED
Home

Power Query Editor.

%3CLINGO-SUB%20id%3D%22lingo-sub-834461%22%20slang%3D%22en-US%22%3EPower%20Query%20Editor.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834461%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20First%20of%20all%2C%20I%20am%20new%20in%20this%20group-Somebody%20should%20welcome%20me!!!%20Otherwise%2C%20I'm%20seeking%20help%20on%20how%20to%20merge%2Fcombine%20over%203%20files%20in%20power%20query%20editor.%20Whenever%20I%20get%20to%20the%20%22get%20data%20from%20folder%22%20option%2C%20the%20first%20file%20automatically%20gets%20selected(or%20sometimes%20I%20only%20have%20one%20option%20to%20select%20of%20all%20the%203%20files)%2C%20making%20difficult%20to%20combine%20all%20the%20files.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%2C%20I%20need%20your%20help.%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-834461%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-834588%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20Editor.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834588%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402595%22%20target%3D%22_blank%22%3E%40Benze_%3C%2FA%3EWelcome%20in%20this%20nuthouse!!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOnce%20you%20have%20the%20preview%20of%20the%20list%20of%20files%2C%20make%20sure%20you%20click%20%22Transform%20data%22.%20Then%20you%20should%20get%20a%20list%20of%20all%20files.%20Filter%20that%20list%20so%20you%20end%20up%20with%20exactly%20the%20files%20you%20want%20to%20combine.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-835946%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20Editor.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-835946%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 Replies
Highlighted
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.

Highlighted
Thank you so much.
Related Conversations
Sorting problem with imported data from query
DenisL in Excel on
5 Replies
Query Design
Siriah in Access on
1 Replies
Power Query freezes in Excel
ire123 in Excel on
4 Replies