The group and summary of data is a common problem encountered during work. For simple requirements such as summing, averaging, and counting, it can be achieved directly using Excel’s group and summary or pivot tables. However, when encountering more ...