Consolidating data from two tables

Excel provides a very simple feature using which we can merge/consolidate data given in two tables which can be logically merged. A typical example of this could be a scenario in which a user gets two data files in TXT format and wants to merge the data in a file. In the last post we saw that we can import data from a TXT file into Excel. If we import two such files in excel we can merge very easily.

STEP 1: Create two tables manually or by importing data from TXT files as shown in the below figure.

STEP 2: In the Data tab click on Consolidate option in Data Tools section.


STEP 3: Select the data sections and Navigate through the pop-up windows. A consolidated data view of selected sections will be shown as shown below.