Forum Discussion
A_SIRAT
Oct 14, 2023Iron Contributor
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.
- Oct 15, 2023
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
Lorenzo
Oct 16, 2023Silver Contributor
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/)
A_SIRAT
Oct 16, 2023Iron Contributor
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.