This can be accomplished, but it will take some playing around with the data.
When importing your file using the Table Files option in your script viewer - once the file has been selected, select the "Enable transformation step" . You will need to get the data to a point where the Product1 field and the Date columns are all aligned (This means that you need to remove the blank rows and the Quarter sections). Once this has been done use the Rotate function that is also in the Transformation steps to pivot the table to get the desired output.
You have no means of accessing the data source from which Excel assembles this overview?
That would make ETL a lot simpler. Now you are facing the pretty complex task of tearing your Excel to pieces and trying to make sense of some of them with number formatting that varies depending on the row header...