Forum Discussion
Remove Duplicate Datasets
Please check below,
Hi,
In the power query right click on the column and click on "Remove Duplicates".
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,
