I would like to know which Excel function to use to merge identities together to fill missing data. In other words I would like to take the following 4 rows:

And end up with 2 consolidated rows like this:

What formula can I use to do this? The combined fruit and initial identities are what need to be matched against each other, and then color and quantity need to be merged. Thanks in advance for any help and advice!

D Quantity A B 4 Fruit Initial 5 Apples A 6 Bananas B 7 Apples A 8 Bananas B C Color Red Yellow Quantity 4 Fruit Initial 5 Apples A 6 Bananas B Color Red Yellow 8