14 Power Query Hacks that Feel Illegal to Know

In this video I'm going to show you Power Query transformation hacks that will help you up your Power Query game.

Download the practice file here: https://docs.google.com/spreadsheets/...

00:00 Hack 1
01:07 Hack 2
01:40 Hack 3
02:15 Hack 4
02:46 Hack 5
03:42 Hack 6
04:21 Hack 7
04:44 Hack 8
05:57 Hack 9
09:01 Hack 10
09:22 Hack 11
11:26 Hack 12
13:10 Hack 13
15:47 Hack 14

✅ Please see link to videos mentioned in this video:
🎦 How to Combine Multiple Files with Inconsistent Column Headers into a Single Sheet -    • How to Combine Multiple Files with In...  
🎦 Power Query Custom Functions -    • Power Query Custom Functions - Easily...  
🎦 Power Query Advanced Editor - What Is It and How to Use It? -    • Getting Started with the Power Query ...  

✅ If you would like to connect on LinkedIn:
🤝   / missmicrosoft  

✅ If you would like to support the channel by buying me a coffee, (it's really quick and easy), please use this link:
☕https://www.buymeacoffee.com/missmicr...

✅ For more videos please subscribe:
🔔   / @missmicrosoft