Consolidating rows with duplicate information

I have a spreadsheet (with ~ 35,000 rows of data) that needs to be consolidated based upon an ID number as found in column A.

What I am looking for is to consolidate 2, 3, or 4 rows (depending upon the number of times the ID number is duplicated) any time the ID number in column A is duplicated.

For example, I may have the following data:

Column A………Column B……… Column C……… Column D
12345677………52X3456T………4428.00…………500.00
98733333………TRT3R23………5000.00…………350.00
98733333………XRU4543………3000.00…………400.00


The desired result is as follows:
Column A………Column B……… ……………Column C……… Column D
12345677………52X3456T……………………4428.00…………500.00
98733333………TRT3R23 / XRU4543………8000.00…………750.00


From the results, you can see that when there are duplicates, I need to concatenate the data in column B with “/” and I need to add the amounts in column C and add the amounts in column D.

I have attached a partial data file with the desired results if this helps.

Thanks for any help.

I tried creating a pivot table to accomplish my task as described in previous thread but it will not work for my ~30,000 rows of data because of excel limitations. Any guidance on how to tackle is appreciated.