Using the Excel Data Model to Combine Multiple Tables into a Single Pivot Table
Typically, users of Excel had to combine multiple tables before creating a Pivot Table - often with VLOOKUP - making the files larger and more complex. In Excel 2016 and Office 365, you can use the Excel Data Model to create Pivot Tables from multiple tables in the workbook.