BYROW replaces thousands of table formulas with one spill formula, making spreadsheets leaner and much more robust.
I traded the static results of Flash Fill for dynamic formulas that update automatically.