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 - [email protected] ===== 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