Excel Flash Fill for Easy Data Cleanup ✨

Stop using formulas, text to columns or macros.
Try Flash Fill first.
It is an intelligent algorithm created by Microsoft Research.
You just given one or two examples of what you want and Excel will figure out the rest.

Download sample file and try it out.
https://efficiency365.com/wp-content/uploads/2023/03/Excel-Flash-Fill-Sample-file.xlsx

Read the research paper by Sumit from Microsoft here.
https://www.microsoft.com/en-us/research/publication/automating-string-processing-spreadsheets-using-input-output-examples/

#excel #data #etl #datacleanup

Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

https://s.efficiency365.com/bk

Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms

Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://s.efficiency365.com/ptyt
Excel to Power BI - https://swiy.io/uxlpbi

Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog

LinkedIn : https://www.linkedin.com/in/nitinparanjape/
Twitter : https://twitter.com/drnitinp

Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativecloud/video.html
AI based captions: https://videoindexer.ai (Microsoft service)