To consolidate is to combine assets, liabilities, and other financial items of two or more entities into one. In the context of financial accounting, the term consolidate often refers to the consolidation of financial statements, where all subsidiaries report under the umbrella of a parent company.

To summarize and report results from data on separate worksheets, you can consolidate the data from each separate worksheet into one worksheet (or master worksheet). The worksheets you consolidate can be in the same workbook as the master worksheet or in other workbooks.

Method 2 Identify Categories to Consolidate Excel Data Repeat the tasks in the first step above for setting up the data in list format. In the master worksheet, click on the upper-left cell where you want to place the consolidated data. Go to the Data Tools Group. Find the Data tab, and then click Consolidate.

to bring together (separate parts) into a single or unified whole; unite; combine: They consolidated their three companies. to discard the unused or unwanted items of and organize the remaining: She consolidated her home library.

Debt consolidation means taking out a new loan to pay off a number of liabilities and consumer debts, generally unsecured ones. In effect, multiple debts are combined into a single, larger piece of debt, usually with more favorable payoff terms: a lower interest rate, lower monthly payment or both.