Power Query Split Column: By Delimiter & Non-Digit to Digit
In this video, learn how to split columns in Power Query using two powerful methods: by delimiter and by non-digit to digit characters. Whether you’re separating text by commas, spaces, or transitioning from letters to numbers, this step-by-step guide will show you how to quickly transform your data. Perfect for anyone looking to clean and organize their datasets efficiently!
#PowerQuery #SplitColumn #DataTransformation #Excel #powerbi
00:00 Introduction
00:45 Simple Splitting
01:16 Provide the splitting result into rows
01:40 Split by non-digit to digit