7.12 Merge data of the same group

 

Here below is an annual and quarterly sales data table:

imagepng

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)

imagepng