How to write a view to de-normalize the table rows?

i have the following table structure with sample data

TranxID RowID Table Description NewValue OldValue

1000          1         Table1      IDX                 1
1000          1         Table1      MAPPING             A
B
1000          2         Table1      IDX                 2
1000          2         Table1      MAPPING             X
Y
1000          1         Table2      IDX                 1
1000          1         Table2      MAPPING             C
D
2000          1         Table1      IDX                 1
2000          1         Table1      MAPPING             B

i want to write a view to group them into the following structure

TranxID RowID Tb1_IDX_New Tb1_IDX_Old Tb1_MAPPING_New Tb1_MAPPING_Old Tb2_IDX_New Tb2_IDX_Old Tb2_MAPPING_New Tb2_MAPPING_Old

1000     1      1                       A               B
1                       C               D
1000     2      2                       X               Y
2000     1      1                       B               U