Forum Discussion
Remove Duplicate Datasets
Please check below,
thanks for the help.
What i am looking for is i wanna remove those repeat rows which are having same ID, name , date, item description, cash amount. It is wrong when you just right click ID column and remove duplicates. Because in my data, you could have same ID but different name and others details.
for examples:
ID Name Date Item Description Cash Amount
1 A 1/1 Apple $5
1 A 1/1 Apple $5
1 A 1/2 Apple $5
Above is the sample of my dataset. So i wanna make sure i remove those repeat rows (for e.g the 1st and 2nd row) which are having exact same ID, Name, Date, Item description and Cash Amount. I had tried to concenate those columns however it doesnt work as the data type are different (some are text, some are number).
Please check below,
how to remove duplicates from 2 different data sources
The Group by solution will work for you. You can group by all 4 columns and this will essentially remove the duplicates.
