In this video, we solve Challenge 136: Splitting a column where a character is repeated consecutively in Power Query. Learn how to break down values like "HNNM" into separate parts where repeating characters occur. This advanced tip is perfect for handling complex text splits and improving your data transformation skills in Power Query!
