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
- I thought I would get a chance to mark it as Best Response since I started the discussion. Anyway, I would have done it again....was just waiting for your second feedback.
- Thank you !.
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/)
