We now have all data from the Data worksheets consolidated onto the Consolidated Data worksheet. Since our data is identified with labels in the left column (the part numbers), we put a check next to Left column: This allows Excel to match up the data from each worksheet and put it together and this is why we also selected the "Part" column in our example for the range references in Step 5.
This is where you tell Excel what it will use to identify the separate pieces of data to consolidate. After adding the last set of data, our Consolidate window looks like this:
#How to consolidate data in excel 2016 how to#
How to Consolidate Data while Keeping Links to the Original Data Steps to Combine and Consolidate Data in Excel This method has Excel do all the work for you so that you don't have to insert any formulas or functions yourself. Simple method to combine data from multiple worksheets into one worksheet. The easiest way to combine and consolidate data in Excel.