Data in columns to rows (not transpose...)

Hi everyone, I am trying to clean up some data, which is organized horizantally AND in rows, as per the attached screenshot.

The fact that there is data horizontally across seven week days and in rows for the weeks of the year makes it impossible for me to use the simple TRANSPOSE feature, of which I am aware...

Does anybody have any idea as to how I can get this solved?

I have quite a couple of worksheets I need to apply this operation on, so manual work is the worst solution...

Thanks to all of you out there!

Titus