Forum Discussion
Question on Consolidation
Hello, could you please tell me, if I have the following data in the multiple worksheet then how can I consolidate the data as per prioriy category. Thank you
Hello spande2415
Easy task with Power Query/Get & Transform if you run Excel >/= 2016 on Windows or 365 on MacOs. Only other requirement is: each data Sheet must be formatted as Table - easy given you seem to have structured data
If you need a sample please share a workbook with (dummy) representative data so no one helping here spend time re-creating something that already exist - Thanks