How to use a formula to have data in 4 different rows in one row?

I have been trying for a long time but still can't seem to solve this issue. Please can a kind soul help me? I have attached the file for reference.

Basically I have a massive file, but I extracted just a few as example. In the file, I want to summarise my result in cell C13 to F14 (yellow section) from the data in cell A1 to F9.

Million thanks for your help.