Power Query Column Splitting Explained - Complete Guide from Basics to Advanced

In this complete tutorial, you’ll learn everything about splitting columns in Power Query using real-world examples in Excel and Power BI. This 40-minute guide starts from the basics and gradually moves to advanced column-splitting techniques used in professional data cleaning and transformation workflows. 🔹 What you’ll learn in this video: Split columns by delimiter Split columns by number of characters Split columns by position Split using space, comma, dash, custom symbols Advanced split scenarios and common mistakes Best practices for clean and scalable Power Query models This video is ideal for: ✔ Excel users ✔ Power BI users ✔ Data analysts ✔ Anyone working with messy text data 00:00 Introduction 00:41 Split by Delimiter 02:06 Split by right most delimiter 03:10 Details of Table.SplitColumn arguments 04:22 Main characteristic of splitter functions 07:00 Create Custom Splitter 12:17 Convert to custom splitter 14:20 Example 2- split from begging to each sections 19:00 Split based on multi-delimiters 24:00 extract lists items in columns instead of rows 27:00 Split based on patterns 36:00 add new columns by splitting command 38:30 Make splitting command dynamic