Advanced data grouping

In one of the previous “recipes” we talked about how to use the Excel GROUPBY function. On that occasion, you could find out how to use it in one of the standard scenarios of its application, and now you will learn how to use it in a slightly more advanced way. To begin with, how you can group by two or more dimensions, and then how to display percentages, determine the depth of the calculation, and so on.

Merging arrays

If you work with a table in which there are several arrays, such as city names or sales values in them, until now you could only combine them by copying and pasting to the desired position in the worksheet. As of a few weeks ago, if you are a Microsoft 365 subscriber, you can also use two functions for working with dynamic arrays: VSTACK and HSTACK. They allow merging arrays which contributes to easier preparation of data for reporting.