Power Query Split Column at Number-to-Text Transitions Challenge 63
Learn how to split a column dynamically in Power Query whenever the character type transitions from a number to text. This video is related to Power Query Challenge 63, and this technique is useful for extracting structured data from mixed-format strings, such as separating product codes from descriptions or splitting IDs from names. Watch the step-by-step guide and enhance your Power Query skills with advanced text transformations! 🚀 #PowerQuery #Excel #datatransformation
00:00 Introduction
00:53 Power Query Editor
02:05 SplitTextbycharactertransition