Use Power Query to Combine Tables

Use Power Query to combine data from different sheets in a workbook,
or from different Excel files, if those tables have some column headings
with identical names. Then, you can create a pivot table from the combined
data

Download the Sample File

Power Query Training: Expand your Excel skills -- learn Power Query at your own pace, in this online course from experts Ken Puls and Miguel Escobar. The course starts with the Power Query basics, and gradually builds up to advanced techniques. There are 15 modules, broken into 55 videos (over 12 hours of content). See all the course details and sign up now.

Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures
Excel newsletter.