Qliksense - Multiple columns into single row

[mon]

Given table 1, table2 are 2 tables... and last line should be the output

[anat]

remove ID field from Table1 then do the left join based on Name

Table1:

Load Name,Country;

Load * inline [

ID,Name,Country

];

left Join(Table1)

load Id,Name,State [

];