I want to create two columns:
Column A with all the countries listed in the photo below
Column B with one of 3 options (Advanced Economies, Emerging Market Economies, Low-Income Developing Countries) to match whichever category it is placed under in the photo below.

So ideally, we'd end up with something that looks like:
Country Type
Australia Advanced Economies
Austria Advanced Economies
Albania Emerging Market Economies
Afghanistan Low-Income Developing Countries

I can do this easily on excel by moving cells around, etc.

But how do I do this with purely Stata? I realize it's not a wide-to-long format reshaping matter.

Thank you in advance,


Array