© 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_13

13. VSTACK and HSTACK: What They’re About

Abbott Ira Katz1  
(1)
Edgware, UK
 

The new VSTACK and HSTACK dynamic array functions perform a kind of act of rescue for the user; they enormously simplify a time-worn data-management task that much of the time could in fact be largely avoided to begin with.

That task is the business of merging or consolidating data that’s been gathered into multiple datasets. A standard example: a freelancer records his income in a series of datasets, each one archiving one year’s worth of activity. In this stereotypical but utterly plausible scenario, our gig economist ...

Get Up Up and Array!: Dynamic Array Formulas for Excel 365 and Beyond now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.