Data not as expected

[rash]

The customer expected to get one table in the data model with the content as shown below. How would you alter the load script to get this result without changing the data in the two sources?

please find the attacment

[sugathirajkumar]

Can you share the datas in those two table ?

[rash]

T1:
LOAD * Inline [
F1, F2
a, 1
a, 2
b, 3
c, 4
];
T2:
LOAD DISTINCT * Inline [
F1, F2
a, 1
b, 3
b, 3
c, 4
];