Flash Fill, which is only available in the Windows version of Excel 2013 and above, helps significantly in a number of data cleaning instances. We can use it to quickly and easily split columns even if they are not consistent.
Split Columns with Flash Fill
You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.