LibreOffice remove duplicate rows

source: https://www.libreofficehelp.com/remove-duplicates-libreoffice-calc-list/

REMOVING (HIDING) DUPLICATE ROWS:

 

MENU:  DATA –>  MORE FILTERS –> ADVANCED FILTERS

1. select the range
2. check “no duplicates”
3. copy paste result to destination sheet