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.