Excel Help.xlsx

Hey,

Could anyone help me with some formulas do put the tables into the format I'm hoping for? I've attached an example of the tables (there are actually 700 of them) and an example of what I'm hoping for.

Thanks in advance!

Rodeam