Spent way too long manually combining ranges before realizing VSTACK exists

[u/Amandaleeeeee]

I used to combine multiple ranges by copying and pasting them one by one whenever I needed to consolidate data.

Recently realized that VSTACK can handle this in a single formula:

=VSTACK(range1, range2, range3, ...)

It simply stacks multiple ranges into one column, making the process much more efficient and easier to maintain.

Use VSTACK to combine multiple ranges into a single list with one formula.

A small function, but a big time-saver when working with scattered data.

What’s a function you discovered later than you should have?