Swapping specific data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AJ
5 - Atom
‎04-05-2023
09:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
Attached is an Excel file with sample of the data I want help with. I have 2 columns, old and new Order numbers. If the Old OrderNo starts with 004**** do nothing, but if it's starts with 002****** then swap the Old Order No with the New OrderNo field.
So for Ex: Old OrderNo from the Excel 0040000637 will not be swapped, however Old OrderNo 0021814608 will be swapped with 0040003320 New OrderNo. Also If the Old OrderNo starts with 002**** and there is No New OrderNo then keep the Old OrderNo. as in the last record in the Excel file
Thoughts?
Thanks.
Labels:
1 REPLY 1
binuacs
21 - Polaris
‎04-06-2023
10:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
