Excel's query tool reshapes messy imports into 1NF, so AVERAGEIFS replaces hacks and your summaries run faster.
(Sorry about that, but we can’t show files that are this big right now.) ...