How to move 'country' column without interrupting other columns

[abardaje]

Hello!

How to move country from  'Country2' column to 'Country1' column without interrupting other columns in Input. 

See attached sample for both input tab and output tab.

[IraWatt]

Hey @abardaje,

Im not entirely sure what output your looking for. Are you just wanting to add the country 1 column into the country 2 dataset like this?

[abardaje]

Apologies. the output that I'm looking for is let say I do have 2 source file same data but the different was the 'Country1' column was my first source file then other one is the 'Country2' column and the output I want is to move all the data from the 'Country2' column to the 'Country1' column without interrupting other column from the from my first source file.

[Robin_McIntosh]

Like this?

[binuacs]

@abardaje may be something like this?

[abardaje]

Thank you all guys but not sure on my end why is it not working maybe because mine has thousands of data, compare to my initial sample above, that lots of different and similar data that 's why it's not working on my end but, I think it's still very helpful, maybe let me try using this logic but with additional idea on how to get the design I want. :)