Alternatives to DeDupe - any ideas?

Hey everyone,

I’ve been using Dedupe, which is ok but very manual. Is there a formula or automation that combines data if two unique identifiers are the same, and where columns are blank (then I can use dedupe)

example in image:
Screenshot 2021-06-11 at 10.35.26 am

Any help much appreciated!

Is there anyone that can help with this guys? Pulling my hair out trying to find a solution!