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.
By David Eitelbach, Laptopmag.com Contributor |
1. Click 'Insert' at the top of the screen.
![Excel Excel](https://img.lovepik.com/excel/40014/2304.jpg!/crop/0x1400a0a0/fw/850/quality/90)
Excel's INDEX function is a powerful function when you want to find a value in a specific row and column location inside a table of data. Our examples used numeric values to identify the row and column values that INDEX should work with.
2. Click the 'PivotTable' button on the Ribbon.
![Excel Summary Table Excel Summary Table](/uploads/1/2/4/9/124933007/931865383.png)
3. Select the first table you want to add to the pivot table.
4. Check the box labeled 'Add this data to the Data Model' and press OK.
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.
6. Check the boxes of the cells you wish to include in the pivot table.