Extract Unique values from the list of Duplicates and copy into another column

Hi there,
I have a request where i want to take out the Unique values from the list of duplicates jobs# & copy the unique jobs# into another column, & then copy the respective status into another column, as shown in the attached Excel ,"Example" sheet

Note: Unique status will be updated only if all the duplicate jobs# has the respective status , else it will be blank

i would appreciate if you could provide me some help on this
pls. find the excel file in the attachment!

Thanking you in anticipation
Abrar