Premium Only Content

Consolidate & Clean Multiple Excel Sheets in One Pivot Table
30 July 2020 Excel Power Query (Get & Transform)
Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/
Excel's Power Query can easily solve a common problem in Excel: Consolidating information from multiple Excel worksheets into one Pivot Table. This also works if you'd like to append data from multiple sheets into a single Excel table.
In this video we'll combine the data from multiple Excel sheets into a single Pivot table in the same workbook. And we'll do it in a dynamic way so that when new sheets are added, we just need to press Refresh on our report. We will also apply Power Query's convenient transformations to clean and prepare the data for our report (fill up empty cells in a table)
⯆ DOWNLOAD the workbook here (scroll to the bottom of the blog post): https://www.xelplus.com/combine-excel-sheets-power-query
Power Query Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyKV86N7i0q9TfYNN8bBjX-
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Time Stamps:
00:00 Combine Data from Multiple Sheets in one PivotTable
01:48 Send data to Power Query
02:25 Send data from all sheets in one go
03:45 Apply Power Query's Data Transformations
04:58 Create Excel Pivot Table on Appended Data
05:38 Exclude End-Report as Data Source in Power Query
07:46 Refresh Report with New Data
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani #powerquery
-
52:40
Candace Show Podcast
1 hour agoSaturday Night Lively: What Were They Thinking? | Candace Ep 148
15.4K26 -
LIVE
Revenge of the Cis
2 hours agoEpisode 1449: Boo This
2,048 watching -
1:20:31
Awaken With JP
3 hours agoWiping Hard Drives, Hire a Criminal Defense Lawyer - LIES Ep 79
44K25 -
1:02:23
In The Litter Box w/ Jewels & Catturd
20 hours agoDEI Kills | In the Litter Box w/ Jewels & Catturd – Ep. 744 – 2/18/2025
39.2K22 -
LIVE
Game On!
2 hours agoBreaking Down COLLEGE BASKETBALL BETTING LINES Like a Pro!
50 watching -
LIVE
John Crump Live
4 hours agoMexico Backs Cartels By Threatening To Designate Gun Manufactures As Terrorist!
220 watching -
LIVE
The Nunn Report - w/ Dan Nunn
2 hours ago[Ep 611] DOGE On The March! | Guest Sam Anthony - [your]NEWS | Seditious Dems | Ukraine
300 watching -
1:00:56
The Tom Renz Show
8 hours agoThe War On DOGE Is ALSO A War On The Economy
4.95K5 -
1:30:16
Steve-O's Wild Ride! Podcast
5 days ago $0.84 earnedAri Shaffir Exposes The Dark Side of Podcasting - Wild Ride #252
11.3K1 -
1:56:29
The Quartering
6 hours agoAirplane FLIPS and CRASHES, Sean Duffy Slams Pete Buttigieg, & What Happened with Patriarchy Hannah
66.8K28