Part of my job is to analyse & explain variances.
This involves combining data sets. The new Excel function - VSTACK - is one way of doing that. It is quick, with simple snytax. Another benefit is that VSTACK is dynamic. If the data sources change, then the combined data set automatically refreshes and updates. It is dynamic. If you were combining data sets into one for an iterative process - e.g. forecast or budget - this is a a huge benefit. Much faster and accurate than other methods.
See the attached file for further details.