Hi

Create an ODBC query with DISTINCT clause, which reads unique data from table with double rows and writes result to another sheet. You also can use SUM, AVEREGE, MIN, etc in query to get some aggregate values. Or you can use formulas like SUMIFS or COUNTIFS in adjacent columns to query table to calculate aggregate values from original data table.