Save the data to Excel. Flash Fill was definitely quicker, but knowing the Power Query method will help when you’re already working with data in Power Query. Read next: Learn how to apply ...