Excel Help

%3CLINGO-SUB%20id%3D%22lingo-sub-1518043%22%20slang%3D%22en-US%22%3EExcel%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518043%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20need%20help%20regarding%20excel%20power%20query%2C%20I%20have%20multiple%20files%20of%20excel%20data%20and%20I%20need%20to%20merge%20all%20data%20in%20one%20sheet%20with%20all%20sequence%20attached%20file%20for%20your%20reference%20I%20want%20to%20update%20my%20all%20data%20through%20power%20query%20excel%202016.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ekindly%20help%20me%20out%20to%20solve%20the%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3CBR%20%2F%3EM.Yasir%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1518043%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1518081%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518081%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F725503%22%20target%3D%22_blank%22%3E%40MuhammadYasir%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20question%20is%20are%20all%20source%20files%20have%20exactly%20the%20same%20structure%20or%20not.%20For%20example%2C%20for%20Sheet%20Blue%20%3CSTRONG%3EDesign%20Number%3C%2FSTRONG%3E%20is%20in%20column%20A%2C%20for%20next%20sample%20is%20in%20column%20B.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1518173%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518173%22%20slang%3D%22en-US%22%3E%3CP%3ESame%20source%20same%20column%20file%20is%20attached%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1520062%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1520062%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F725503%22%20target%3D%22_blank%22%3E%40MuhammadYasir%3C%2FA%3E%26nbsp%3B%2C%20Try%20this.%20Make%20sure%20you%20change%20the%20file%20path%20in%20the%20setup%20tab%20to%20point%20to%20your%20location.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

I need help regarding excel power query, I have multiple files of excel data and I need to merge all data in one sheet with all sequence attached file for your reference I want to update my all data through power query excel 2016.

 

kindly help me out to solve the issue.

 

Thanks
M.Yasir

3 Replies
Highlighted

@MuhammadYasir 

The question is are all source files have exactly the same structure or not. For example, for Sheet Blue Design Number is in column A, for next sample is in column B.

Highlighted

Same source same column file is attached@Sergei Baklan 

Highlighted

@MuhammadYasir , Try this. Make sure you change the file path in the setup tab to point to your location.