I am trying to find a way to merge rows based upon a value in column A:

For example:
A1 = Jake-----B1 (Blank)-------C1 "Orange"--------D1 (Blank)
A2 = Jake-----B2 "Apple"------C2 "Blank"-----------D1 (Blank)
A3 = Jake-----B3 (Blank)-------c3 "Blank"-----------D1 "Banana"

I would like the end result to be:

A1 = Jake-----B1 "Apple"------C1 "Orange"------D1 "Banana"


On a side note Column 'A' will contain multiple names that will need to be
combined in the same way shown.

Thanks in advance,

Jake
Jake