I have two lists I want to "merge". They both have Order Number as a column.
I want to combine them into one list, and each list is over 3000 rows long.
How do I do this? Also - the order numbers aren't matching unless I retype
them in one of the lists (without changing any formatting). What's with that?

John