Forum Discussion

Iron Contributor

Oct 14, 2023

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.

Labels.xlsx36 KB

excel

Formulas and Functions

Lorenzo
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

Silver Contributor

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

A_SIRAT

Iron Contributor

Oct 15, 2023

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.