Is there any reason you can't uses a dashboard where you show each week in the column format you want, then have the sheets side by side?
If I understood you right.. l'll combine two dashboards..first time it works..but it is not dynamic right?
Any day i refresh the report again it should pick it up automatically
It'd be easier to answer with a packaged workbook but by default it wouldn't be dynamic. But you may be able to write a calculation to always default to the most recent date.