Pivot Table without Pivot App

ariestauro

I would like to summarize three columns of a sheet with the same first three digits of an account within the same sheet. In Excel, I use a Pivot Table. Please see picture below of the before and after to hopefully illustrate what I mean. Is there a way to create what I want without having the Pivot App?

CodyRussell

You can do this by creating a row report, using this grid as the source sheet, and then using the group/summarize features in the report.