Consolidating data excel; microsoft.support = microsoft.support
The following screenshot demonstrates one of possible results.
Excel's Consolidate feature's claim to fame is merging and summarizing values from multiple workbooks.
It's a great tool for combining data when several users work with different instances of the same file.
And then, run the Consolidate Worksheets Wizard, and select the option Copy data only for the matching columns in my first table in the list.
As the result, the Consolidate Worksheets Wizard will find identically named columns in other sheets that you've selected and copy data only from those columns.