Data modelling

Hi All,

Just wondering what you found to be best practice when creating a PowerBI dashboard from hard coded excel files. 

In short I have to create a new dashboard with work, but the data i have to use is a hard coded table which is updated weekly by simply inserting a new column every week. Is there a way to condese this into a better format? I have attatched a mock up example of the data below with some fake figures.

Any help at all is very much appreciated, thank you.