9.7 Deduplication of simple data

 

There is a data table:

imagepng

Deduplicate the data:

=spl("=?1.id()",A2:A17)

imagepng