Use formulas instead of Power Query for tidy files, with a visible source path and clear parameters that teammates can review ...
Five formulas, fewer clicks, and a lot less spreadsheet suffering.
How-To Geek on MSN
How to use formula by example in Excel to generate complex formulas
I traded the static results of Flash Fill for dynamic formulas that update automatically.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results