How to do it...

To implement this recipe, do the following:

1. Create the following table, that is, R07_Table:

R07_Table = 
    VAR __Table1 = 'R07_Table3x4'
    VAR __Table2 = 'R07_Table4x2'
    VAR __Table2a = 
        SELECTCOLUMNS(
            {
                (
                    SELECTCOLUMNS(FILTER(__Table2,[Index]=1),"Row",[Column1]), 
                    SELECTCOLUMNS(FILTER(__Table2,[Index]=2),"Row",[Column1]), 
                    SELECTCOLUMNS(FILTER(__Table2,[Index]=3),"Row",[Column1]), 
                    SELECTCOLUMNS(FILTER(__Table2,[Index]=4),"Row",[Column1]),
                    "1"
                ),
                (
                    SELECTCOLUMNS(FILTER(__Table2,[Index]=1),"Row",[Column2]), 
                    SELECTCOLUMNS(FILTER(__Table2,[Index]=2),"Row",[Column2]), 
                    SELECTCOLUMNS(FILTER(__Table2,[Index]=3),"Row",[Column2]), 
                    SELECTCOLUMNS(FILTER(__Table2,[Index]=4),"Row",[Column2]),
                    "2"
                )
            },
            "Row",[Value5],
            "1",[Value1],
            "2",[Value2],
            "3",[Value3],
            "4",[Value4]
        )
    VAR __Table3 = 
        ADDCOLUMNS(
            GENERATE(
                SELECTCOLUMNS(
                    __Table1,
                    "Row",[Index],
                    "Column1",[Column1],
                    "Column2",[Column2],
                    "Column3",[Column3],
                    "Column4",[Column4]),
                SELECTCOLUMNS(
                    __Table2a,
                    "Column",[Row],
                    "1",[1],
                    "2",[2],
                    "3",[3],
                    "4",[4])
            ),
            "Value",[Column1]*[1] + [Column2]*[2] + [Column3]*[3] + [Column4]*[4]
        )
    VAR __Table3a =
        SELECTCOLUMNS(
            {
                (
                    SELECTCOLUMNS(FILTER(__Table3,[Row]=1 && [Column]="1"),"Value",[Value]), 
                    SELECTCOLUMNS(FILTER(__Table3,[Row]=1 && [Column]="2"),"Value",[Value]),
                    1
                ),
                (
                    SELECTCOLUMNS(FILTER(__Table3,[Row]=2 && [Column]="1"),"Value",[Value]), 
                    SELECTCOLUMNS(FILTER(__Table3,[Row]=2 && [Column]="2"),"Value",[Value]),
                    2
                ),
                (
                    SELECTCOLUMNS(FILTER(__Table3,[Row]=3 && [Column]="1"),"Value",[Value]), 
                    SELECTCOLUMNS(FILTER(__Table3,[Row]=3 && [Column]="2"),"Value",[Value]),
                    3
                )              
            },
            "Row",[Value3],
            "1",[Value1],
            "2",[Value2]
        )
RETURN
    __Table3a