Microsoft Excel is one of the most popular tools out there for number-crunching. However, there are a plethora of other ways ...
Use formulas instead of Power Query for tidy files, with a visible source path and clear parameters that teammates can review ...
I traded the static results of Flash Fill for dynamic formulas that update automatically.