Our range of data that includes the column and row labels is ‘B3: E7’.
Each of four regions, North, South, East, and West have sales figures for all the products. Once cell ‘C4’ is highlighted, we go to ‘Consolidate’ in the ‘Data Tools’ section of the ‘Data’ tab in the ribbon.
If you merge multiple columns of data in Excel (no matter which Excel version you are using), only the left column of data will be kept, and the data of other columns will be deleted, if you apply the "Merge and Center" command from Home tab on the Alignment group.
This tutorial is talking about how to merge or combine different columns of data into one column.
It automatically selects the same range so long as each subsequent worksheet has the same layout (i.e., the table begins at the same cell as ours at ‘B2’). In this, we got a single table that shows the sum for all tables being consolidated.
Note, that this consolidated table only contains static values.