Project Status Report > Horizontal View


In our team project trackers, we are leveraging worksheets with grandparent/parent/child relationships to organize by the the different business/clients/projects. Our desired automated reporting output is to transpose most of what is captured in a row format into a column to enable a snapshot view that is horizontal in layout. Below is an image of our desired output.

I have searched other questions for a recent solve, but not seeing anything exactly like we are looking for. Any recommendations for how we can easily solve for this? We unfortunately need to find a quick solve, so hoping there are existing templates or formulas we could easily implement.