Up Up and Array!: Dynamic Array Formulas for Excel 365 and Beyond

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

A. I. KatzUp Up and Array!https://doi.org/10.1007/978-1-4842-8966-2_11

11. TOCOL and TOROW: Straightening Out the Data

Abbott Ira Katz¹  

(1)

Edgware, UK

 

To reiterate an introductory point we made a short while ago: Excel’s new, second-generation dynamic array functions don’t open many new windows on number crunching; rather, they’re primarily about revamping and streamlining the way in which data can be organized. And that’s a point that surely calls for some explanation, beginning with a description of the TOROW and TOCOL functions.

How They’re Written – and What They’re About

TOCOL and TOROW were crafted to allow users simpler means for analyzing data that’s ...