Convert multiple column values to rows

Well... I created a new calculated column:

 Area# = "Area" & RIGHT ( Data[Area], 1 )

and placed it in the column field in the matrix visual.

Then created a new measure and added it to the matrix values:

MyValues = 
IF (
    ISINSCOPE ( Data[ID] ),
    VALUES ( Data[Result] ),
    VALUES ( Data[Area] )
)

In the Matrix Row I added both the Type and ID.

In Power BI file options, I disabled the use of modern visual headers. 

And in the matrix visual format, I adjusted the subtotals as follows:

and made the column headers white (same as background to make  them invisible).

Please check this sample file.