![how to combine 2 pivot tables in excel 2013 how to combine 2 pivot tables in excel 2013](https://support.content.office.net/en-us/media/470a56f2-039a-46c2-af74-8d7f95783812.gif)
How to combine 2 pivot tables in excel 2013 update#
If a source range expands, you can update the range for the name in the separate worksheet to include the new data before you refresh the PivotTable. Then use those names when you consolidate the ranges in the master worksheet. If the range of data is likely to change the next time that you consolidate the data (that is, the number of rows may change), consider defining a name for each source range in the separate worksheets. The following example shows a consolidated PivotTable that has one page field and multiple items selected. For example, if you're consolidating budget data from the Marketing, Sales, and Manufacturing departments, a page field can include one item to show the data for each department, plus an item to show the combined data. The following example shows four ranges in cross-tab format.ĭata consolidation can use page fields that contain items representing one or more of the source ranges. Do not include any total rows or total columns from the source data when you specify the data for the report. Setting up the source dataĮach range of data should be arranged in cross-tab format, with matching row and column names for items that you want to summarize together. In addition, the report can have up to four page filter fields, called, ,, and. The resulting consolidated PivotTable report can have the following fields in the PivotTable Field List, which you can add to the PivotTable: Row, Column, and Value.
![how to combine 2 pivot tables in excel 2013 how to combine 2 pivot tables in excel 2013](https://i0.wp.com/beatexcel.com/wp-content/uploads/2013/10/pivot-table-row-labels.png)
When you consolidate data, you are assembling it so that you can more easily update and aggregate data regularly or as needed. The separate worksheet ranges can be in the same workbook as the master worksheet or in a different workbook. 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.