Delete cells using Alteryx like how it is possible in Excel

[Kallis]

Hello Friends

I have 2 files without any key

I need to merge these files. I have given the input and the expected output. Kindly help.

Input

Expected Output

[alexnajm · Accepted solution]

Split them out (either with a Filter or with Select Records tools) and then Join (but by Record Position) - you can Union back any remaining

[Kallis]

Thanks @alexnajm 

Let me try this solution

[Kallis]

Thanks @alexnajm 

It works

[alexnajm]

Fantastic news!