No need for importing the data into another table. What you describe is usually referred to as a "cross tab" report and you can search this forum and others using that phrase to find numerous discussions and examples of such a report.
One approach for what you show is to set up a list view layout where each record in the layout's table represents a different week of a given year. The columns of data would be produced with either a series of one row filtered portals with a summary field from the portal's table (your table 1) placed inside the portal row as the sole field. It's also possible to use calculation fields with ExecuteSQL() calculations in place of the portals to produce the same result.
Thanks a lot for pointing me in the right direction!