Jul 12 2020 11:17 PM
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
Jul 12 2020 11:48 PM
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.
Jul 13 2020 12:39 AM
Same source same column file is attached@Sergei Baklan
Jul 13 2020 04:59 PM
@MuhammadYasir , Try this. Make sure you change the file path in the setup tab to point to your location.