Power Query / Complex Data Transformation / Multiple Headers

Hello BI Community,   I am working with a data source that is excel based and I am very limited in the changes I can make with the structure. See below photos as a reference, photo 1 shows the scru...