I ran into an issue, that may or may not be resolvable.
My client has a "Bill to:" and a "Ship to:" in their raw data.
However the address data is always combined on the same line.
For example, here is some raw data from the sheet. Bear in mind this is all converted from .txt to .xls, and...