Here below is an annual and quarterly sales data table:

In this table, column A is ordered and has duplicate values. Now we want to clear the data from all rows in the same group except the first row.

=spl("=E(?1).group(#1).(~.run(if(#==1,,#1=null))).conj()",A1:C21)

https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1654923852094
https://c.scudata.com/article/1654990593574