Spreadsheet: 41417d1239886122-pulling-data-from-list-if-cell-blank-then-move-to-next-remove-blanks
Sheet: Sheet2

from sheet 1 | rank | blanks removed |  | copied then pasted special values to remove formula
Albania | 2 | Algeria |  | Algeria
Algeria | 3 | Argentina |  | Argentina
 |  | Armenia |  | Armenia
Argentina | 5 | Australia |  | Australia
Armenia | 6 | [NAME] |  | [NAME]
Australia | 7 | Bahrain |  | Bahrain
[NAME] | 8 | Bangladesh |  | Bangladesh
 |  | Barbados |  | Barbados
Bahrain | 10 | Belarus |  | Belarus
Bangladesh | 11 | Belize |  | Belize
Barbados | 12 | Bolivia |  | Bolivia
Belarus | 13 | Botswana |  | Botswana
 |  | Brazil |  | Brazil
Belize | 15 | Brunei |  | Brunei
Bolivia | 16 | Cameroon |  | Cameroon
Botswana | 17 | Canada |  | Canada
Brazil | 18 | China |  | China
Brunei | 19 | Colombia |  | Colombia
 |  | Costa Rica |  | Costa Rica
 |  | Croatia |  | Croatia
 |  | Cuba |  | Cuba
Cameroon | 23 | Cyprus |  | Cyprus
Canada | 24 | Czech Republic |  | Czech Republic
 |  | Democratic Republic of the Congo |  | Democratic Republic of the Congo
China | 26 | Denmark |  | Denmark
Colombia | 27 | Djibouti |  | Djibouti
Costa Rica | 28 | French [NAME] |  | French [NAME]
Croatia | 29 | Gambia |  | Gambia
Cuba | 30 | Georgia |  | Georgia
Cyprus | 31 | Germany |  | Germany
Czech Republic | 32 | Ghana |  | Ghana
Democratic Republic of the Congo | 33 | Greece |  | Greece
Denmark | 34 | Guam |  | Guam
Djibouti | 35 | Guatemala |  | Guatemala
French [NAME] | 36 | Guyana |  | Guyana
Gambia | 37 | Hong Kong |  | Hong Kong
Georgia | 38 | Hungary |  | Hungary
Germany | 39 | Iceland |  | Iceland
Ghana | 40 | India |  | India
Greece | 41 | Iran |  | Iran
Guam | 42 | Israel |  | Israel
Guatemala | 43 | Italy |  | Italy
Guyana | 44 | Ivory Coast |  | Ivory Coast
Hong Kong | 45 | Jamaica |  | Jamaica
Hungary | 46 | Japan |  | Japan
Iceland | 47 | Kazakhstan |  | Kazakhstan
India | 48 | Kenya |  | Kenya
 |  | Kuwait |  | Kuwait
Iran | 50 | Kyrgyzstan |  | Kyrgyzstan
Israel | 51 | Laos |  | Laos
Italy | 52 | Latvia |  | Latvia
Ivory Coast | 53 | Lebanon |  | Lebanon
Jamaica | 54 | [NAME] |  | [NAME]
Japan | 55 | Libya |  | Libya
 |  | Lithuania |  | Lithuania
Kazakhstan | 57 | Luxemburg |  | Luxemburg
Kenya | 58 | Macau |  | Macau
 |  | Macedonia |  | Macedonia
Kuwait | 60 | Madagascar |  | Madagascar
Kyrgyzstan | 61 | [NAME] |  | [NAME]
Laos | 62 | Malaysia |  | Malaysia
Latvia | 63 | Malta |  | Malta
Lebanon | 64 | Mexico |  | Mexico
[NAME] | 65 | Moldova |  | Moldova
Libya | 66 | Mongolia |  | Mongolia
Lithuania | 67 | Morocco |  | Morocco
Luxemburg | 68 | Mozambique |  | Mozambique
Macau | 69 | Namibia |  | Namibia
Macedonia | 70 | [NAME] |  | [NAME]
Madagascar | 71 | Netherlands |  | Netherlands
[NAME] | 72 | New Zealand |  | New Zealand
Malaysia | 73 | Oman |  | Oman
Malta | 74 | Pakistan |  | Pakistan
 |  | Panama |  | Panama
 |  | [NAME] |  | [NAME]
Mexico | 77 | Paraguay |  | Paraguay
Moldova | 78 | Peru |  | Peru
Mongolia | 79 | Philippines |  | Philippines
Morocco | 80 | Poland |  | Poland
Mozambique | 81 | Portugal |  | Portugal
Namibia | 82 | Puerto Rico |  | Puerto Rico
[NAME] | 83 | Qatar |  | Qatar
Netherlands | 84 | Republic of Ireland |  | Republic of Ireland
New Zealand | 85 | Reunion |  | Reunion
 |  | Russia |  | Russia
 |  | Rwanda |  | Rwanda
Oman | 88 | Saudi Arabia |  | Saudi Arabia
Pakistan | 89 | Senegal |  | Senegal
Panama | 90 | Slovakia |  | Slovakia
[NAME] | 91
Paraguay | 92
Peru | 93
Philippines | 94
Poland | 95
Portugal | 96
Puerto Rico | 97
Qatar | 98
Republic of Ireland | 99
Reunion | 100
Russia | 102
Rwanda | 103
Saudi Arabia | 105
Senegal | 106
Slovakia | 108