Looking at your "From" and "To" data it looks as simple as the following (assuming your data starts in A2).
I suspect however that it is not this simple. You mention that the result you want can be in either of 2 columns, but your sample data does not reflect that.
Please attach a workbook with sufficient sample data to cover all necessary cases along with your expected results for each.
To attach a file, first make sure to remove any sensitive/proprietary data and then click on “GO ADVANCED” and then scroll down to “Manage Attachments” to open the upload window. Choose your file then click on “Upload”, scroll down then click on “Close this window”, then “Submit reply”.
Thanks
Geoff
Bookmarks