BYROW replaces thousands of table formulas with one spill formula, making spreadsheets leaner and much more robust.

Lock dynamic arrays into fixed shapes so dashboards stay neat, tables stack cleanly, and templates keep their layout.

Excel's query tool reshapes messy imports into 1NF, so AVERAGEIFS replaces hacks and your summaries run faster.

Correspondence to Dr Brent E Hagel, Department of Paediatrics, Cumming School of Medicine, University of Calgary, Calgary, AB T2N 1N4, Canada; brent.hagel{at}albertahealthservices.ca Background ...

Daniel Liberto is a journalist with over 10 years of experience working with publications such as the Financial Times, The Independent, and Investors Chronicle. David Kindness is a Certified Public ...