if statement

[radhikaa4]

Currently I have this table below:

status	not_recruiting	status1	recruiting
ABCD	1		1
EFGH	1	EFGH	1
HIJK	1	HIJK	1
LMNO	1		1
QRST	1	QRST	1

Basically if status and status1 are not blank then I want the final site_status = "Recruiting"

if status1 is blank then i want the final status to be site_status = "Not recruiting" 

and I want to delete all the duplicates

i can get the if statement to work but i do not want to create more additional datasets. want to delete in one step

[PaigeMiller]

Duplicates? I don't see any.

[Reeza]

Show what you have as input, what you want as output and what you've tried please. Its the fastest way to get an answer.