Excel: Combine Multiple Sheets into One Master Tab
Learn to merge data from multiple Excel sheets into a single master tab using Power Query and auto-expand tables. 📊
Learn Google Sheets & Excel Spreadsheets
778.6K views • Nov 9, 2017
About this video
Learn how to Combine Data From Multiple Sheets (Tabs) in Microsoft Excel using Power Query, auto expandable Table Objects and make an automatic master sheet with all the data combined into one tab.
Updated Versions:
Use Table Names with Dynamic Updates https://youtu.be/Je1sKHrVwuU
Include Worksheet Names https://youtu.be/bRnXAz4KaYM
Install add-in for Excel 2010/2013 users https://www.microsoft.com/en-us/download/details.aspx?id=39379
Updated Versions:
Use Table Names with Dynamic Updates https://youtu.be/Je1sKHrVwuU
Include Worksheet Names https://youtu.be/bRnXAz4KaYM
Install add-in for Excel 2010/2013 users https://www.microsoft.com/en-us/download/details.aspx?id=39379
Tags and Topics
Browse our collection to discover more content in these categories.
Video Information
Views
778.6K
Likes
4.0K
Duration
19:31
Published
Nov 9, 2017
User Reviews
4.2
(155)