I used to hate cleaning data in an Excel sheet because it was tedious and repetitive. It often took longer than expected, not because the work itself was difficult, but because I needed time to build enough mental energy to push through the monotony. At some point, Excel introduced powerful features to clean up dirty sheets, and one that I use often is Flash Fill.
Source: You’re wasting time in Excel if you aren’t using Flash Fill
