PQ-search for data with just a few letters from a data table

[sandy666]

Country of the world	Population		Select Country		Country of the world	Population
Albania	2,877,797		Belg		Australia	25499884
Algeria	43,851,044		Aus		Austria	9006398
Andorra	77,265		Bul		Belgium	11589623
Angola	32,866,272		Bra		Bhutan	771608
Antigua and Barbuda	97,929		Burk		Brazil	212559417
Argentina	45,195,774		Moz		Bulgaria	6948445
Armenia	2,963,243		Bh		Burkina Faso	20903273
Australia	25,499,884		So		Moldova	4033963
Austria	9,006,398		V		Monaco	39242
Azerbaijan	10,139,177		Mo		Mongolia	3278290
Bahamas	393,244				Montenegro	628066
Bahrain	1,701,575				Morocco	36910560
Bangladesh	164,689,383				Mozambique	31255435
Barbados	287,375				Solomon Islands	686884
Belarus	9,449,323				Somalia	15893222
Belgium	11,589,623				South Africa	59308690
Belize	397,628				South Korea	51269185
Benin	12,123,200				South Sudan	11193725
Bhutan	771,608				Vanuatu	307145
Bolivia	11,673,021				Venezuela	28435940
Bosnia and Herzegovina	3,280,819				Vietnam	97338579
Botswana	2,351,627
Brazil	212,559,417
Brunei	437,479
Bulgaria	6,948,445
Burkina Faso	20,903,273
Burundi	11,890,784
Côte d'Ivoire	26,378,274
Cabo Verde	555,987

source data is much bigger so see attachment

// Table1
let
    Table2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    List = Table.AddColumn(Source, "List", each Table2[Select Country]),
    Exp = Table.ExpandListColumn(List, "List"),
    IF = Table.AddColumn(Exp, "Country", each if Text.StartsWith([Country of the world], [List]) then [Country of the world] else null),
    NullOut = Table.SelectRows(IF, each ([Country] <> null)),
    TSC = Table.SelectColumns(NullOut,{"Country of the world", "Population"}),
    SortA = Table.Sort(TSC,{{"Country of the world", Order.Ascending}}),
    TD = Table.Distinct(SortA, {"Country of the world"})
in
    TD

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=Ugy_RiNN_kAqUvZ8W994AaABAg
https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNsaS3Lp1
https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgR1EPUkhw
https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNe_XC-jK
https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNPOdiDuv
https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgN7AC7wAc
https://www.youtube.com/watch?v=bs-urI_o8jo&lc=UgyBACXgNY4j_cHgH5J4AaABAg.9oTkVdzfqfm 9wlhQrYJP3M
https://www.youtube.com/watch?v=bs-urI_o8jo&lc=UgxYgiEZuS9I3xkjJv54AaABAg
https://www.youtube.com/watch?v=DVFFApHzYVk&lc=Ugyi578yhj9zShmhuPl4AaABAg
https://www.youtube.com/watch?v=GqzeFYWjTxI&lc=UgxvxlnuTRWiV6MUZB14AaABAg
https://www.youtube.com/watch?v=_8i1fVEi5WY&lc=Ugz0ptwE5J-2CpX4Lzh4AaABAg
https://www.youtube.com/watch?v=0ltJS7uHfK4&lc=UgxoHAw8RwR7VmyVBUt4AaABAg. 9C-br0lEl8V9xI0_6pCaR9
https://www.youtube.com/watch?v=0ltJS7uHfK4&lc=Ugz5DDCMqmHLeEjUU8t4AaABAg. 9bl7m03Onql9xI-ar3Z0ME
https://www.youtube.com/watch?v=0ltJS7uHfK4&lc=UgxYnpd9leriPmc8rPd4AaABAg. 9gdrYDocLIm9xI-2ZpVF-q
https://www.youtube.com/watch?v=0ltJS7uHfK4&lc=UgyjoPLjNeIAOMVH_u94AaABAg. 9id_Q3FO8Lp9xHyeYSuv1I
https://www.reddit.com/r/windowsxp/comments/pexq9q/comment/k81ybvj/?utm_source=reddit&utm_medium=web2x&context=3
https://www.youtube.com/watch?v=bs-urI_o8jo&lc=UgxYgiEZuS9I3xkjJv54AaABAg
https://www.youtube.com/watch?v=bs-urI_o8jo&lc=UgyBACXgNY4j_cHgH5J4AaABAg.9oTkVdzfqfm 9wlhQrYJP3M
ttps://www.youtube.com/watch?v=LP9fz2DCMBE
https://www.youtube.com/watch?v=LP9fz2DCMBE&lc=UgzbPgJUMCztIOQDym14AaABAg
https://www.youtube.com/watch?v=LP9fz2DCMBE&lc=UgzbPgJUMCztIOQDym14AaABAg. 9wdo_rWgxSH9wdpcYqrvp8
ttps://www.youtube.com/watch?v=bFxnXH4-L1A
https://www.youtube.com/watch?v=bFxnXH4-L1A&lc=UgxuODisjo6cvom7O-B4AaABAg.9w_AeS3JiK09wdi2XviwLG
https://www.youtube.com/watch?v=bFxnXH4-L1A&lc=UgxBU39bTptFznDC1PJ4AaABAg
ttps://www.youtube.com/watch?v=GqzeFYWjTxI
https://www.youtube.com/watch?v=GqzeFYWjTxI&lc=UgwJnJDJ5JT8hFvibt14AaABAg
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA