You may use the Statistics by categories algorithm from the Processing Toolbox and set these parameters:
Field to calculates statistics on
: "Column 1"2" (or whatever fields that stores the area values);Field with categories
: "Column 2"1" (or whatever field that stores the polygon types).
You will obtain a CSV file containing statistics for the fields set (as min, max, mean, standard deviation, sum, count).