Merge Two Lists Without Losing Their Order

Try the workflow

Paste the lists into A and B and choose Merge unique items. The tool reads A first and then appends any new exact values from B. Open the tool.

Copy the example

001
003
003

002
003

Check the result

The result is 001, 003, 002 in that order. If duplicates are meaningful, choose Append. Use Compare Lists to review the differences before merging.