Excel Unpivot Data with Multiple Headers (Multiple Row levels into Columns with Power Query)
16 July 2020 Excel Power Query (Get & Transform)
Check Out the Complete Excel Power Query course: https://www.xelplus.com/course/excel-power-query/
Stop wasting time creating complex formulas to transpose data in columns with multiple headers to get proper tabular data. With Excel's Power Query you can easily create a dynamic solution to transform your report-style data into a dataset you can use to run Pivot Tables on or do further analysis on with formulas.
Unpivot means to create rows from columns. For example if you have a sales report and the months Jan - Dec are each reported in its own column. By Unpivoting we "shrink" this report with 12 columns for the months into a tabular format where all months are consolidated in one column and the data is shown in the rows. This way your data is properly structured for further analysis.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-advanced-unpivot-power-query
LINK to Unpivot video: https://youtu.be/JMrfbv2h7p8
★ 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/
EXCEL 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
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Time Stamps:
00:00 Purpose of UnPivot in Excel
02:27 Prepare data for Excel Power Query
04:44 Use Power Query Editor to Unpivot Data
10:06 Test Dynamic Solution when adding new data
11:26 Remove empty cells from report
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
-
3:32:48
Due Dissidence
9 hours agoMorning Joe and Hillary SMEAR Students, DNC Fears CONVENTION CHAOS, Carville MELTS DOWN Again
11.3K51 -
1:22:39
The Late Kick with Josh Pate
7 hours agoLate Kick Live Ep 512: Portal Winners & Losers | SEC Truths + Questions | Portal Winners & Losers
8.57K1 -
1:50:27
vivafrei
13 hours agoEp. 210: Stormy Gags on Lies! Hunter Not Immune! AstraZeneca Pulled & MORE! Viva & Barnes
97.7K157 -
1:50:54
Jewels Jones Live
2 days agoUNDERSTANDING NEXTGEN MARXISM | A Political Rendezvous - Ep. 76
40.6K38 -
8:22:56
Akademiks
1 day agoAll Will Be Revealed! Drake vs Kendrick vs The Riddler. Who Lied, Who Snaked, Mole Finally Revealed!
127K103 -
1:08:38
Russell Brand
2 days ago“You’re Going To Get KILLED!” Mike Benz EXPOSES CIA Secrets Like NEVER Before - Stay Free #363
365K774 -
1:35:13
Roseanne Barr
2 days ago $74.67 earnedKeep My Name Out Yo M*Therf*Cking Mouth! | The Roseanne Barr Podcast #47
170K408 -
1:19:00
Steven Crowder
3 days agoBradley Martyn and Vitaly's Hollywood Pedo Bust Goes Wrong! Guests: Alex Rosen | Vivek Ramaswamy
661K1.09K -
53:40
The Osbournes
5 days ago $1.07 earnedWould You Eat a Monkey? Osbourne's Wildest Meals
70.8K14 -
1:19:01
Steve-O's Wild Ride! Podcast
3 days agoMike The Situation Went To Prison & Owes Millions, But Remains Grateful - Wild Ride #213
79.4K12