How to eliminate both duplicates lines

[rbeneteli]

Hello guys, my problem is the one in the subject, it looks like simple but i can't find a solution, so in my table if I have a duplicate line they are errors and I would like to eliminate both, how can I do that in power query? Sometimes the value appears more than two times.

Fruits

Orange

Banana

Apple

Orange

Orange

Melon

It should be like that

Fruits

Banana

Apple

Melon

[Vvelarde · Accepted solution]

@rbeneteli

Hi,

1--Do a Merge with the Same Table

Fruits With Fruits

2 --When Expand the Table Select Aggregate - Count of Fruits

3--Filter This New Column is equal to 1.

Regards

Victor

[rbeneteli]

@Vvelarde

Thanki you, it worked