9.10 Deduplication of simple data - keeping order

 

There is a data table:

imagepng

Duplicate the data, and keep the original order:

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

imagepng


https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1655858953409
https://c.scudata.com/article/1655949636337