Pivot Table without Pivot App

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?