How to remove duplicates without affecting the blank cells?
Hii Team, I have a dataset which is a join of a user name and phone number and their transactions ID however I need to remove duplicate transaction ID without removing the blank cells as if the user has no transaction ID against it. That means that user has not conducted any transactions. Eg: Dataset Sr No Name Transaction…