UNIQUE Values From A Collection Column With A Blank At The Top

Input collection: myCities55

CityContinentCountry
New YorkNorth AmericaUSA
LondonEuropeUnited Kingdom
KyotoAsiaJapan
OsakaAsiaJapan
Los AngelesNorth AmericaUSA
ParisEuropeFrance
BirminghamEuropeUnited Kingdom


Output value: mySolution55 (unique Country names)

Result
blank
USA
United Kingdom
Japan
France


Solution code:

//Create a collection
ClearCollect(myCities55,
{City: "New York", Country: "USA", Continent: "North America"},
{City: "London", Country:"United Kingdom", Continent: "Europe"},
{City: "Kyoto", Country: "Japan", Continent: "Asia"},
{City: "Osaka", Country: "Japan", Continent: "Asia"},
{City: "Los Angeles", Country: "USA", Continent: "North America"},
{City: "Paris", Country: "France", Continent: "Europe"},
{City: "Birmingham", Country:"United Kingdom", Continent: "Europe"}
);

//Duplicate removal code
ClearCollect(mySolution55, {Result: Blank()});
Collect(mySolution55,Distinct(myCities55,Country));