I traded the static results of Flash Fill for dynamic formulas that update automatically.
Make Excel evaluate your data for you.