A_SIRATIron ContributorOct 14, 2023SolvedHelp 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 KBLorenzoOct 15, 2023Hi A_SIRAT With Get & Transform aka Power Query. Assumed your Order sheets are named 1, 2, 3... 70 as in the file you sharedPQ_OrdersConsolidation.xlsx49 KB
LorenzoOct 15, 2023Hi A_SIRAT With Get & Transform aka Power Query. Assumed your Order sheets are named 1, 2, 3... 70 as in the file you sharedPQ_OrdersConsolidation.xlsx49 KB
LorenzoOct 15, 2023Hi A_SIRAT With Get & Transform aka Power Query. Assumed your Order sheets are named 1, 2, 3... 70 as in the file you sharedPQ_OrdersConsolidation.xlsx49 KB
