Split by Variable Columns in Power Query

Check out our newly launched M Language course ↗️ - https://goodly.co.in/learn-m-powerquery/

The default Split by feature in Power Query produces a fixed number of columns. In this videos I'll share an interesting M technique to split by Variable Columns in Power Query. Enjoy!


===== 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/
Split by Delimiter Blog - https://www.goodly.co.in/split-by-var...


===== CONTACT 🌐 =====
Twitter -   / chandeep2786  
LinkedIn -   / chandeepchhabra  
Email - goodly.wordpress@gmail.com


===== CHAPTERS =====
0:00 Intro
0:37 Split by Columns - The Problem
2:23 The Logic
4:22 The Solution
12:09 Testing the Solution
13:02 My Courses


===== 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'd find a ton of interesting videos that I have created :) Cheers!


- - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
Source: https://goo.gl/fh3rEJ​
Official After The Fall YouTube Channel Below
https://www.youtube.com/channel/UCGQE...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: https://creativecommons.org/licenses