How to Create a Pivot Table Based on Multiple Tables in Excel 2013

  • MORE

how to create pivottable lead 675403

Up until recently, if you had data spread across several tables in Microsoft Excel that you wanted to consolidate in a single pivot table, you would have faced a headache-inducing process of manual formatting and data preparation. The most recent version of the software, Excel 2013, fixes this problem by allowing you to create a pivot table from multiple tables automatically -- no manual formatting required. Just follow these steps to get started.

1. Click "Insert" at the top of the screen.

how to create pivottable 1 click insert 675403

2. Click the "PivotTable" button on the Ribbon.

how to create pivottable 2 click pivottable 675403

3. Select the first table you want to add to the pivot table.

how to create pivottable 3 select table 675403

4. Check the box labeled "Add this data to the Data Model" and press OK.

how to create pivottable 4 check add 675403

5. Click "All" in the PivotTable Fields window to view all of the tables. Excel automatically detects multiple tables, so you won't need to repeat these steps for each additional table.

how to create pivottable 5 click all 675403

6. Check the boxes of the cells you wish to include in the pivot table.

how to create pivottable 6 check boxes 675403

Add a comment
  • Didn't help me much Says:

    Right, that's cute.... but utterly useless!

  • AprilK Says:

    Ah - I figured out what step was missed. Prior to doing anything, each spreadsheet must created as a "named table". After you have the named tables, once the first table is added to the Data Model, it will then pick up the other one :)

  • AprilK Says:

    Same boat as everyone do we add the additional sheets?

  • Graham Says:

    I must have missed something. How do I add a second, third, etc table to the data model?

  • Jose Mujica Says:

    Are you serious? This can not be helpful
    We're talking to append data


    If a user with excel 2013 creates a pivot table with multiple sheets that have different columns can a excel 2010 user use it?

  • HeyAdmin Says:

    Like the article, but what if the tables are on different sheets?

Back to top