Automated Excel Data Formatting

This is a very simple project.

We Generate an Excel file each month for our phone system.

We are looking for some excel program / function that will go through the call log and categorize the sub organisations and calculate the cost for them on a separate sheet.

For example the excel export (Outgoing Call) will have columns such as: Organization ID, Company name, Call cost etc. with hundreds of rows with various values in them. The aim is to have the program to extract and sort the unique Organzation ID and Company name and calculate the total call cost for that organisation and put those in a separate report sheet.

Example of Raw data:
Company ID | Company Name | Call Cost
1 | XYZ | £value
2 | ABC | £value
1 | XYZ | £value
1 | XYZ | £value
2 | ABC | £value
2 | ABC | £value

and so on...

Example Processed Data (On a New Sheet):

Company ID | Company Name | Total Call Cost
1 | XYZ | £sum_value
2 | ABC | £sum_value

and so on..