What's the calculation to delete duplicate lines/data?

[EV]

What's the calculation to delete duplicate lines/data? consolidate

 

[Frank Kabel]

Hi
try 'Data - Filter - Advanced Filter' and check 'Unique entries'