I am trying to create a file which has certain rows which repeat itself (e.g. shown in the excel file attached). I have some invoice numbers and some blank spaces for those invoices numbers. I don’t want to delete the invoice numbers which repeat itself but rather delete the one which is repeating on other column (also shown in the excel file). Can anyone tell me how can I deal with this situation? I have used drop duplicates and it doesn’t work for this criteria
Can you post a minimal reproducible code?
I have solved it thanks for the help 