Transform 999+ column data into something sensible

hi Dr0idy 

You could try this way as below:

Step1:

Selected all the columns except Area column, then unpivot these columns.

Step2:

Then split Attribute column to Indicator column and Year column.

Step3:

Now rename the column.

Result:

and here is sample pbix file, please try it.