Handling two header rows with Power Query - also applies to Power BI
9.5 هزار بار بازدید -
3 سال پیش
-
Double Header rows in Excel.
Double Header rows in Excel. The source of so much heartache. For this example, we will take it a step further as we will also have two header columns, and of course, our end goal is to have a normalized table. This video will feature an advanced Power Query tutorial on dealing with double header rows in Power Query. The question does make sense since Power Query only allows for one header row, so we will use many transformation tricks to get to the final result. Enjoy!
This tutorial was made using Excel 365, but the techniques shown apply to all Excel versions containing Power Query (from 2010 onwards).
Chapters:
0:00 Excel Olympics Animation
0:08 Introduction to the sample data
1:23 Smaller Example
2:04 Example with double header rows
4:28 Fill Down
4:53 Merging Columns
5:33 Transpose command
5:56 Use First Row As Headers
6:28 UnPivot Other Columns
8:22 Conclusion
9:31 Outro
Blog Post: https://bit.ly/31p6uSv
Gear Used:
US Links
Camera: Canon EOS R6 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - https://amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP
Laptop: Dell XPS 15 - https://amzn.to/3effMmT
Lights: Elgato Key Light - https://amzn.to/3vcs6v9
Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y
Recorded With: Camtasia - https://www.techsmith.com/video-edito...
Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub
Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK
Disclaimer: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support!
#Excel #ExcelOlympics #gasperkamensek
This tutorial was made using Excel 365, but the techniques shown apply to all Excel versions containing Power Query (from 2010 onwards).
Chapters:
0:00 Excel Olympics Animation
0:08 Introduction to the sample data
1:23 Smaller Example
2:04 Example with double header rows
4:28 Fill Down
4:53 Merging Columns
5:33 Transpose command
5:56 Use First Row As Headers
6:28 UnPivot Other Columns
8:22 Conclusion
9:31 Outro
Blog Post: https://bit.ly/31p6uSv
Gear Used:
US Links
Camera: Canon EOS R6 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - https://amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP
Laptop: Dell XPS 15 - https://amzn.to/3effMmT
Lights: Elgato Key Light - https://amzn.to/3vcs6v9
Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y
Recorded With: Camtasia - https://www.techsmith.com/video-edito...
Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub
Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK
Disclaimer: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support!
#Excel #ExcelOlympics #gasperkamensek
3 سال پیش
در تاریخ 1400/08/11 منتشر شده
است.
9,519
بـار بازدید شده