Forum Discussion
Solved
Help to consolidate Data into one sheet.
Hi, I have attached an example file and would really appreciate your help. I have explained what I want on the last sheet named consolidated data. thanks in advance.
Hi A_SIRAT
With Get & Transform aka Power Query. Assumed your Order sheets are named 1, 2, 3... 70 as in the file you shared
Thank you !.
This has done exactly what I want.
Would you mind to share the steps then I will do more practice.
This has done exactly what I want.
Would you mind to share the steps then I will do more practice.
Would you mind to share the steps then I will do more practice
Which step(s) causes you a challenge?
(Power Query doc. is available https://learn.microsoft.com/en-us/powerquery-m/)
With the help of Power Query, would you be able to do further consolidation as explained in the attached sheet.
Thanks in advance.
- Let me first dive into Power query to learn as a beginner as I found it very helpful. Thanks for the template you prepared. It has solved my problem.