When reducing/combining duplicated rows by multiple reference columns with numeric values, the 2nd reference column and on were calculated,
E.g. With following data,
Choose Worksheet: Reduce/Combine Duplicated Rows
Choose 1st two columns as reference columns.
Set Merge Duplication by Sum.
==> After clicking OK, the 2nd reference column set were not kept, instead, it was added up.