CODE EXAMPLE FOR JAVASCRIPT

gsheet query select remove header

=QUERY(QUERY(A2:C, "SELECT B, AVG(C) WHERE NOT B = '' GROUP BY B", 0), "SELECT * OFFSET 1", 0)