This video demonstrates how to group data based on one column and produce the partial sum of another column. This method emulates the "Group by" functionality of SQL.
This demo was made using Microsoft Excel 2016.
Source: http://bytefreaks.net/applications/of...