Consolidating missing data across multiple rows into one complete row

Hi,

I’m trying to tidy up some data before doing some analysis.

The data I am reviewing comes from some management reporting for services and orders raised for those services. Each service delivered has a unique identifier; this unique identify has multiple entries for each time a supplier sends in a new invoices which may be for the services or for expenses.

What I want to do is combine the data that is across multiple rows into a complete dataset.

For example;
Column A is the unique id, under column c the expenses column is sometimes complete and other times not; I need this to be added up and inserted into column c for the total sum so I can then delete duplicates;

Unique Reference ID Item Title Service Cost Expenses
62746 Service A 1000.00 0.00
68081 Service B 2000.00 0.00
68081 Service B 0.00 7.00
60689 Service C 4000.00 0.00
50507176 Service D 1,000.00 1235.99
60689 Service C 500.00

The correct outcome would be for Service B;
Unique Reference ID Item Title Service Cost Expenses
68081 Service B 2000.00 7.00

I've tried vlook up but this isnt returning the expenses and completing the sum.

Can anyone suggest the correct formual.

Many thanks

Hi Glenn,

On your spreadsheet the correct outcome happens, however when I've tried to pull this across to my spreadsheet the formula doesnt work.
When you click to edit the formula in G2 and click enter, all the data disappears! :-(