Production Schedule with Horizontal View

We currently utilize excel to map out production by week, per product

I would like to utilize Smartsheet, below is a sample of data entered in a Smartsheet Worksheet/Grid. PO's may be for multiple quantities, same part number (haven't looked at grouping as child rows yet), or mulitiple part numbers on one PO.

I can group by Year/Week and create a report with a vertical view, sample below, but this does not give production the visibility they would like to see.

Before I dig in to this too deeply....If I create columns with week numbers, can I get similar results? The worksheet displays just a few of the columns/information I need to capture.