Excel - Master the VSTACK Formula
VSTACK (Vertical Stacking) has a cool and sounds like the be-all for combining different column data into one. But it has it's downfalls. Check this video to understand this tricky formula.
See the 2nd video in this Shorts Series filtering out blank cells in a dynamic array from two worksheets!
• Excel Dynamic Arrays with TOCOL and VSTACK
See the 3rd video alphabetizing dynamic (spilled) data.
• Excel - Sort Function with Dynamic Arrays