Check out the M Language course and learn to push beyond the UI - https://goodly.co.in/learn-m-powerque...
   • Split by Variable Columns in Power Query  

In this video, we dive deep into Power Query and explore the fascinating world of the M language, specifically focusing on the concept of lists to make it easier for you to navigate and leverage its power in Excel.

Don't miss out on this insightful session with @OzduSoleilDATA, where we simplify the intricacies of the M language, empowering you to work smarter in Power Query.

Also, don't forget to check out Oz's Channel -    / @ozdusoleildata@uczgovykporbszqfy9yysirq  

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
https://goodly.co.in/learn-dax-powerbi/

✔️ Power Query Course-
https://goodly.co.in/learn-power-query/

✔️ Master Excel Step-by-Step-
https://goodly.co.in/learn-excel/

✔️ Business Intelligence Dashboards-
https://goodly.co.in/learn-excel-dash...


===== LINKS 🔗 =====
Blog 📰 - https://www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - https://www.goodly.co.in/training/
Need my help on a Project 💻- https://www.goodly.co.in/consulting/


===== CONTACT 🌐 =====
Twitter -   / chandeep2786  
LinkedIn -   / chandeepchhabra  
Email - [email protected]


===== CHAPTERS =====
00:00 Intro
04:44 About Global Excel Summit
08:08 What is a List?
10:09 Extracting Values as a List
16:41 Dynamic Expansion
32:40 Dynamic Unpivoting
43:29 Dynamic Splitting
50:30 The Advantages of Mastering M for UI-Oriented Users


===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
#powerquery #mlanguage #excel