Append an existing field by inserting multiple rows from a reference file

[dvedwards01]

I have a data set that consists of multiple IDs, which apply to numerous countries throughout the world. The example I've provided is only 10 rows for simplicity sake, but this file I'm working with is ~10K+ rows. Occasionally, the data set owner would simply list the word "Global" for a country, if the ID conditions applied to every jurisdiction in the world (column A), instead of listing out each entry for each respective country that the condition applies to.

For example, take row 2 in the below screen shot & attached excel file. ID "123" has a "Global" origin, meaning it would apply to every country in the world. Instead of listing "Global" for all of these entries in the file I have, I need to append rows below ID 123 that account for each country in the list, minus the entry for "Global". The country list that I've attached possesses 256 countries, so I would essentially need 256 entries that are duplicative, with the one exception of the Origin or Destination, which would be unique.

Any guidance from someone on a path forward would be greatly appreciated! Thanks in advance.

[Inactive User · Accepted solution]

Please see answer attached.

[dvedwards01]

Thanks Ryan, that solved the need here. I appreciate the quick response on this.