This site uses cookies. By continuing, your consent is assumed. Learn more

99.4fm shares

Consolidating excel 2019 worksheets into one


Consolidating data is a useful way to combine data from different sources into one report. For example, if you have a PivotTable of expense figures for each of your regional offices, you can use a data consolidation to roll up these figures into a corporate expense report. This report can contain sales totals and averages, current inventory levels, and highest selling products for the whole enterprise.

To summarize and report results from separate worksheet ranges, you can consolidate data from each separate worksheet range into a PivotTable on a master worksheet. The separate worksheet ranges can be in the same workbook as the master worksheet or in a different workbook. When you consolidate data, you are assembling it so that you can more easily update and aggregate data regularly or as needed.

Excel for Office for Mac...

Row, Column, and Value. In addition, the report can have up to four page filter fields, called Page1, Page2, Page3, and Page4. Each range of data should be arranged in cross-tab format, with matching row and column names for items that you want to summarize together.

Consolidating data is a useful...

Do not include any total rows or total columns from the source data when you specify the data for the report. The following example shows four ranges in cross-tab format.

News feed