Convert Multiple Tables into a Single Pivot Table with Power Query | Everyday Office
Power Query, Excel's new ETL tool, has an Append functionality that lets you pull multiple tables into one. This data could be in multiple files, or in this example, it could be all the tables in a specific file.
Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on:
http://www.knacktraining.com/blog/
http://www.knacktraining.com/podcast/
Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.