Delete cells using Alteryx like how it is possible in Excel

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

Developer

Accepted answers

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

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

Let me try this solution

It works

Fantastic news!