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.

Q: I receive client files with text on multiple lines that are all part of the same sentence. How can I easily incorporate all the text in one cell? A: You can combine text that is separated into ...