Using the Consolidate tool in Excel to merge and summarize data from separate ranges into a single output.
Screenshot of Excel's "Consolidate" feature in the Data tab, showing a dialog box with functions and reference ranges for summarizing data from multiple sheets.
Quality Assured by Worksheets Library Team
Reviewed for educational accuracy and age-appropriateness
ID: #737204