GROUPBY
Formula Explanation
You can create a new table and perform data aggregation directly using data column CODEs in the index column (the first column).
Formula Syntax
In the index column of the new table: Enter the column numbers to be aggregated
- Columns to be aggregated: Columns that need to be aggregated, for example: AB3, AC12.
- All parameters can be data columns, using the CODE at the top of each column, for example: AA1.
Usage Example
Perform data aggregation on column CX2, and write the results into column CY1.
CY1 = CX2