Grouping continents together

%3CLINGO-SUB%20id%3D%22lingo-sub-1288001%22%20slang%3D%22en-US%22%3EGrouping%20continents%20together%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1288001%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3EHey%20there%2C%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3EI'm%20trying%20to%20group%20a%20bunch%20of%20countries%20I%20have%20(200%2B)%20into%20their%20continents.%20I%20do%20not%20have%20the%20continents%20which%20they%20go%20under%2C%20just%20the%20name%20of%20the%20country.%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3ENote%3A%20I%20only%20have%20the%20country%20names.%20Not%20the%20continent%20which%20they%20are%20located%20in.%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3EHow%20would%20I%20group%20them%20into%20their%20continents%20without%20manually%20typing%20which%20continent%20that%20they%20fit%20under%3F%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3EThank%20you%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1288001%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1288074%22%20slang%3D%22en-US%22%3ERe%3A%20Grouping%20continents%20together%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1288074%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F612496%22%20target%3D%22_blank%22%3E%40alexanderluong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EConduct%20a%20web%20search%20for%20data%20you%20can%20download.%26nbsp%3B%20There%20seems%20to%20be%20any%20number%20of%20sources.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Hey there,
I'm trying to group a bunch of countries I have (200+) into their continents. I do not have the continents which they go under, just the name of the country.
Note: I only have the country names. Not the continent which they are located in.
How would I group them into their continents without manually typing which continent that they fit under?
Thank you
1 Reply
Highlighted

@alexanderluong 

Conduct a web search for data you can download.  There seems to be any number of sources.