In the following table, the 1^st column is the grouping column and there are N detail data columns after it.

The computing task: group rows by the 1^st column; insert the maximum value and the minimum value of each column in each group in order into the 2N columns horizontally.

Use SPL XLL to enter the following formula:

=spl("=f=(d=E(?)).fname().m(2:),d.groups(Z;${f.( replace( ""max(*):*Max,min(*):*Min"", ""*"", ~ )).concat@c()})",A1:D9)

fname()function gets column names of the table. groups() function groups the rows and perform aggregations. m(:2) gets members from the 2^nd to the last, and ~ represents the current members. ${} takes the string as a dynamical code to execute.

Source:https://stackoverflow.com/questions/78375603/find-the-maximum-and-minimum-values-from-a-range-set-by-cells-containg-specific