Miraculous Automatic Data Cleanup in Excel

This is the continuation of data cleanup series. In this article we discuss a newly introduced feature “Flash Fill” which is almost miraculous and difficult to believe. When I demonstrate this feature during my seminars, most people suspect that I am playing some kind of trick!

It opens up a new way of handling data cleaning tasks which would have either been very time consuming or impossible using existing methods.

image

Continue reading