Spreadsheet: 838742d1691335734-alternate-data-in-columns-a-and-b-aabab-aabab-repeat-and-input-to-column-e-sampleworksheet
Sheet: Sheet2

Country | Number | - | What I would like to see - in this order (AABAB repeat down each column)
Afghanistan | 1 | - | Afghanistan
Albania | 2 | - | Albania |  | Albania
Algeria | 3 | - | 1 |  | 1
Andorra | 4 | - | Algeria |  | Algeria
Angola | 5 | - | 2 |  | 2
[NAME] and [NAME] | 6 | - | Andorra |  | Andorra
Argentina | 7 | - | Angola |  | Angola
Armenia | 8 | - | 3 |  | 3
Australia | 9 |  | [NAME] and [NAME] |  | [NAME] and [NAME]
Austria | 10 |  | 4 |  | 4
Austrian Empire* | 11 |  | And so on down each A and B column to 5000 in depth |  | Argentina
Azerbaijan | 12 |  |  |  | Armenia
Baden* | 13 |  |  |  | 5
Bahamas, The | 14 |  |  |  | Australia
Bahrain | 15 |  |  |  | 6
Bangladesh | 16 |  |  |  | Austria
Barbados | 17 |  |  |  | Austrian Empire*
Bavaria* | 18 |  |  |  | 7
Belarus | 19 |  |  |  | Azerbaijan
Belgium | 20 |  |  |  | 8
Belize | 21 |  |  |  | Baden*
Benin (Dahomey) | 22 |  |  |  | Bahamas, The
Bolivia | 23 |  |  |  | 9
Bosnia and Herzegovina | 24 |  |  |  | Bahrain
Botswana | 25 |  |  |  | 10
Brazil | 26 |  |  |  | Bangladesh
Brunei | 27 |  |  |  | Barbados
Brunswick and Lüneburg | 28 |  |  |  | 11
Bulgaria | 29 |  |  |  | Bavaria*
[NAME] (Upper Volta) | 30 |  |  |  | 12
Burma | 31 |  |  |  | Belarus
Burundi | 32 |  |  |  | Belgium
Cabo Verde | 33 |  |  |  | 13
Cambodia | 34 |  |  |  | Belize
Cameroon | 35 |  |  |  | 14
Canada | 36 |  |  |  | Benin (Dahomey)
Cayman Islands, The | 37 |  |  |  | Bolivia
Central African Republic | 38 |  |  |  | 15
Central American Federation* | 39 |  |  |  | Bosnia and Herzegovina
Chad | 40 |  |  |  | 16
Chile | 41 |  |  |  | Botswana
China | 42 |  |  |  | Brazil
Colombia | 43 |  |  |  | 17
Comoros | 44 |  |  |  | Brunei
Congo Free State, The* | 45 |  |  |  | 18
Costa Rica | 46 |  |  |  | Brunswick and Lüneburg
Cote d’Ivoire (Ivory Coast) | 47 |  |  |  | Bulgaria
Croatia | 48 |  |  |  | 19
Cuba | 49 |  |  |  | [NAME] (Upper Volta)
Cyprus | 50 |  |  |  | 20
Czechia | 51 |  |  |  | Burma
Czechoslovakia | 52 |  |  |  | Burundi
Democratic Republic of the Congo | 53 |  |  |  | 21
Denmark | 54 |  |  |  | Cabo Verde
Djibouti | 55 |  |  |  | 22
Dominica | 56 |  |  |  | Cambodia
Dominican Republic | 57 |  |  |  | Cameroon
Duchy of Parma, The* | 58 |  |  |  | 23
East Germany (German Democratic Republic)* | 59 |  |  |  | Canada
Ecuador | 60 |  |  |  | 24
Egypt | 61 |  |  |  | Cayman Islands, The
El Salvador | 62 |  |  |  | Central African Republic
Equatorial Guinea | 63 |  |  |  | 25
Eritrea | 64 |  |  |  | Central American Federation*
Estonia | 65 |  |  |  | 26
Eswatini | 66 |  |  |  | Chad
Ethiopia | 67 |  |  |  | Chile
Federal Government of Germany (1848-49)* | 68 |  |  |  | 27
Fiji | 69 |  |  |  | China
Finland | 70 |  |  |  | 28
France | 71 |  |  |  | Colombia
Gabon | 72 |  |  |  | Comoros
Gambia, The | 73 |  |  |  | 29
Georgia | 74 |  |  |  | Congo Free State, The*
Germany | 75 |  |  |  | 30
Ghana | 76 |  |  |  | Costa Rica
Grand Duchy of Tuscany, The* | 77 |  |  |  | Cote d’Ivoire (Ivory Coast)
Greece | 78 |  |  |  | 31
Grenada | 79 |  |  |  | Croatia
Guatemala | 80 |  |  |  | 32
Guinea | 81 |  |  |  | Cuba
Guinea-Bissau | 82 |  |  |  | Cyprus
Guyana | 83 |  |  |  | 33
Haiti | 84 |  |  |  | Czechia
Hanover* | 85 |  |  |  | 34
Hanseatic Republics* | 86 |  |  |  | Czechoslovakia
Hawaii* | 87 |  |  |  | Democratic Republic of the Congo
Hesse* | 88 |  |  |  | 35
Holy See | 89 |  |  |  | Denmark
Honduras | 90 |  |  |  | 36
Hungary | 91 |  |  |  | Djibouti
Iceland | 92 |  |  |  | Dominica
India | 93 |  |  |  | 37
Indonesia | 94 |  |  |  | Dominican Republic
Iran | 95 |  |  |  | 38
Iraq | 96 |  |  |  | Duchy of Parma, The*
Ireland | 97 |  |  |  | East Germany (German Democratic Republic)*
Israel | 98 |  |  |  | 39
Italy | 99 |  |  |  | Ecuador
Jamaica | 100 |  |  |  | 40
Japan | 101 |  |  |  | Egypt
Jordan | 102 |  |  |  | El Salvador
Kazakhstan | 103 |  |  |  | 41
Kenya | 104 |  |  |  | Equatorial Guinea
Kingdom of Serbia/Yugoslavia* | 105 |  |  |  | 42
Kiribati | 106 |  |  |  | Eritrea
Korea | 107 |  |  |  | Estonia
Kosovo | 108 |  |  |  | 43
Kuwait | 109 |  |  |  | Eswatini
Kyrgyzstan | 110 |  |  |  | 44
Laos | 111 |  |  |  | Ethiopia
Latvia | 112 |  |  |  | Federal Government of Germany (1848-49)*
Lebanon | 113 |  |  |  | 45
[NAME] | 114 |  |  |  | Fiji
Lew Chew (Loochoo)* | 115 |  |  |  | 46
Liberia | 116 |  |  |  | Finland
Libya | 117 |  |  |  | France
[NAME] | 118 |  |  |  | 47
Lithuania | 119 |  |  |  | Gabon
Luxembourg | 120 |  |  |  | 48
Madagascar | 121 |  |  |  | Gambia, The
[NAME] | 122 |  |  |  | Georgia
Malaysia | 123 |  |  |  | 49
Maldives | 124 |  |  |  | Germany
[NAME] | 125 |  |  |  | 50
Malta | 126 |  |  |  | Ghana
Marshall Islands | 127 |  |  |  | Grand Duchy of Tuscany, The*
Mauritania | 128 |  |  |  | 51
[NAME] | 129 |  |  |  | Greece
[NAME] | 130 |  |  |  | 52
Mecklenburg-Strelitz* | 131 |  |  |  | Grenada
Mexico | 132 |  |  |  | Guatemala
[NAME] | 133 |  |  |  | 53
Moldova | 134 |  |  |  | Guinea
Monaco | 135 |  |  |  | 54
Mongolia | 136 |  |  |  | Guinea-Bissau
Montenegro | 137 |  |  |  | Guyana
Morocco | 138 |  |  |  | 55
Mozambique | 139 |  |  |  | Haiti
Namibia | 140 |  |  |  | 56
Nassau* | 141 |  |  |  | Hanover*
Nauru | 142 |  |  |  | Hanseatic Republics*
Nepal | 143 |  |  |  | 57
Netherlands, The | 144 |  |  |  | Hawaii*
New Zealand | 145 |  |  |  | 58
Nicaragua | 146 |  |  |  | Hesse*
[NAME] | 147 |  |  |  | Holy See
Nigeria | 148 |  |  |  | 59
North German Confederation* | 149 |  |  |  | Honduras
North German Union* | 150 |  |  |  | 60
North Macedonia | 151 |  |  |  | Hungary
Norway | 152 |  |  |  | Iceland
Oldenburg* | 153 |  |  |  | 61
Oman | 154 |  |  |  | India
Orange Free State* | 155 |  |  |  | 62
Pakistan | 156 |  |  |  | Indonesia
Palau | 157 |  |  |  | Iran
Panama | 158 |  |  |  | 63
Papal States* | 159 |  |  |  | Iraq
[NAME] | 160 |  |  |  | 64
Paraguay | 161 |  |  |  | Ireland
Peru | 162 |  |  |  | Israel
Philippines | 163 |  |  |  | 65
Piedmont-Sardinia* | 164 |  |  |  | Italy
Poland | 165 |  |  |  | 66
Portugal | 166 |  |  |  | Jamaica
Qatar | 167 |  |  |  | Japan
Republic of Genoa* | 168 |  |  |  | 67
Republic of Korea (South Korea) | 169 |  |  |  | Jordan
Republic of the Congo | 170 |  |  |  | 68
Romania | 171 |  |  |  | Kazakhstan
Russia | 172 |  |  |  | Kenya
Rwanda | 173 |  |  |  | 69
[NAME] Nevis | 174 |  |  |  | Kingdom of Serbia/Yugoslavia*
[NAME] | 175 |  |  |  | 70
Saint Vincent and the Grenadines | 176 |  |  |  | Kiribati
Samoa | 177 |  |  |  | Korea
[NAME] | 178 |  |  |  | 71
Sao Tome and Principe | 179 |  |  |  | Kosovo
Saudi Arabia | 180 |  |  |  | 72
Schaumburg-Lippe* | 181 |  |  |  | Kuwait
Senegal | 182 |  |  |  | Kyrgyzstan
Serbia | 183 |  |  |  | 73
Seychelles | 184 |  |  |  | Laos
Sierra Leone | 185 |  |  |  | 74
Singapore | 186 |  |  |  | Latvia
Slovakia | 187 |  |  |  | Lebanon
Slovenia | 188 |  |  |  | 75
[NAME], The | 189 |  |  |  | [NAME]
Somalia | 190 |  |  |  | 76
South Africa | 191 |  |  |  | Lew Chew (Loochoo)*
South Sudan | 192 |  |  |  | Liberia
Spain | 193 |  |  |  | 77
[NAME] | 194 |  |  |  | Libya
Sudan | 195 |  |  |  | 78
Suriname | 196 |  |  |  | [NAME]
Sweden | 197 |  |  |  | Lithuania
Switzerland | 198 |  |  |  | 79
Syria | 199 |  |  |  | Luxembourg
Tajikistan | 200 |  |  |  | 80
Tanzania | 201 |  |  |  | Madagascar
Texas* | 202 |  |  |  | [NAME]
Thailand | 203 |  |  |  | 81
Timor-Leste | 204 |  |  |  | Malaysia
Togo | 205 |  |  |  | 82
Tonga | 206 |  |  |  | Maldives
Trinidad and Tobago | 207 |  |  |  | [NAME]
Tunisia | 208 |  |  |  | 83
Turkey | 209 |  |  |  | Malta
Turkmenistan | 210 |  |  |  | 84
Tuvalu | 211 |  |  |  | Marshall Islands
Two Sicilies* | 212 |  |  |  | Mauritania
Uganda | 213 |  |  |  | 85
Ukraine | 214 |  |  |  | [NAME]
Union of Soviet Socialist Republics* | 215 |  |  |  | 86
United Arab Emirates, The | 216 |  |  |  | [NAME]
United Kingdom, The | 217 |  |  |  | Mecklenburg-Strelitz*
Uruguay | 218 |  |  |  | 87
Uzbekistan | 219 |  |  |  | Mexico
[NAME] | 220 |  |  |  | 88
Venezuela | 221 |  |  |  | [NAME]
Vietnam | 222 |  |  |  | Moldova
Württemberg* | 223 |  |  |  | 89
Yemen | 224 |  |  |  | Monaco
Zambia | 225 |  |  |  | 90
Zimbabwe | 226 |  |  |  | Mongolia
 | 227 |  |  |  | Montenegro
 | 228 |  |  |  | 91
 | 229 |  |  |  | Morocco
 | 230 |  |  |  | 92
 | 231 |  |  |  | Mozambique
 | 232 |  |  |  | Namibia
 | 233 |  |  |  | 93
 | 234 |  |  |  | Nassau*
 | 235 |  |  |  | 94
 | 236 |  |  |  | Nauru
 | 237 |  |  |  | Nepal
 | 238 |  |  |  | 95
 | 239 |  |  |  | Netherlands, The
 | 240 |  |  |  | 96
 | 241 |  |  |  | New Zealand
 | 242 |  |  |  | Nicaragua
 | 243 |  |  |  | 97
 | 244 |  |  |  | [NAME]
 | 245 |  |  |  | 98
 | 246 |  |  |  | Nigeria
 | 247 |  |  |  | North German Confederation*
 | 248 |  |  |  | 99
 | 249 |  |  |  | North German Union*
 | 250 |  |  |  | 100
 | 251 |  |  |  | North Macedonia
 | 252 |  |  |  | Norway
 | 253 |  |  |  | 101
 | 254 |  |  |  | Oldenburg*
 | 255 |  |  |  | 102
 | 256 |  |  |  | Oman
 | 257 |  |  |  | Orange Free State*
 | 258 |  |  |  | 103
 | 259 |  |  |  | Pakistan
 | 260 |  |  |  | 104
 | 261 |  |  |  | Palau
 | 262 |  |  |  | Panama
 | 263 |  |  |  | 105
 | 264 |  |  |  | Papal States*
 | 265 |  |  |  | 106
 | 266 |  |  |  | [NAME]
 | 267 |  |  |  | Paraguay
 | 268 |  |  |  | 107
 | 269 |  |  |  | Peru
 | 270 |  |  |  | 108
 | 271 |  |  |  | Philippines
 | 272 |  |  |  | Piedmont-Sardinia*
 | 273 |  |  |  | 109
 | 274 |  |  |  | Poland
 | 275 |  |  |  | 110
 | 276 |  |  |  | Portugal
 | 277 |  |  |  | Qatar
 | 278 |  |  |  | 111
 | 279 |  |  |  | Republic of Genoa*
 | 280 |  |  |  | 112
 | 281 |  |  |  | Republic of Korea (South Korea)
 | 282 |  |  |  | Republic of the Congo
 | 283 |  |  |  | 113
 | 284 |  |  |  | Romania
 | 285 |  |  |  | 114
 | 286 |  |  |  | Russia
 | 287 |  |  |  | Rwanda
 | 288 |  |  |  | 115
 | 289 |  |  |  | [NAME] Nevis
 | 290 |  |  |  | 116
 | 291 |  |  |  | [NAME]
 | 292 |  |  |  | Saint Vincent and the Grenadines
 | 293 |  |  |  | 117
 | 294 |  |  |  | Samoa
 | 295 |  |  |  | 118
 | 296 |  |  |  | [NAME]
 | 297 |  |  |  | Sao Tome and Principe
 | 298 |  |  |  | 119
 | 299 |  |  |  | Saudi Arabia
 | 300 |  |  |  | 120
 |  |  |  |  | Schaumburg-Lippe*
 |  |  |  |  | Senegal
 |  |  |  |  | 121
 |  |  |  |  | Serbia
 |  |  |  |  | 122
 |  |  |  |  | Seychelles
 |  |  |  |  | Sierra Leone
 |  |  |  |  | 123
 |  |  |  |  | Singapore
 |  |  |  |  | 124
 |  |  |  |  | Slovakia
 |  |  |  |  | Slovenia
 |  |  |  |  | 125
 |  |  |  |  | [NAME], The
 |  |  |  |  | 126
 |  |  |  |  | Somalia
 |  |  |  |  | South Africa
 |  |  |  |  | 127
 |  |  |  |  | South Sudan
 |  |  |  |  | 128
 |  |  |  |  | Spain
 |  |  |  |  | [NAME]
 |  |  |  |  | 129
 |  |  |  |  | Sudan
 |  |  |  |  | 130
 |  |  |  |  | Suriname
 |  |  |  |  | Sweden
 |  |  |  |  | 131
 |  |  |  |  | Switzerland
 |  |  |  |  | 132
 |  |  |  |  | Syria
 |  |  |  |  | Tajikistan
 |  |  |  |  | 133
 |  |  |  |  | Tanzania
 |  |  |  |  | 134
 |  |  |  |  | Texas*
 |  |  |  |  | Thailand
 |  |  |  |  | 135
 |  |  |  |  | Timor-Leste
 |  |  |  |  | 136
 |  |  |  |  | Togo
 |  |  |  |  | Tonga
 |  |  |  |  | 137
 |  |  |  |  | Trinidad and Tobago
 |  |  |  |  | 138
 |  |  |  |  | Tunisia
 |  |  |  |  | Turkey
 |  |  |  |  | 139
 |  |  |  |  | Turkmenistan
 |  |  |  |  | 140
 |  |  |  |  | Tuvalu
 |  |  |  |  | Two Sicilies*
 |  |  |  |  | 141
 |  |  |  |  | Uganda
 |  |  |  |  | 142
 |  |  |  |  | Ukraine
 |  |  |  |  | Union of Soviet Socialist Republics*
 |  |  |  |  | 143
 |  |  |  |  | United Arab Emirates, The
 |  |  |  |  | 144
 |  |  |  |  | United Kingdom, The
 |  |  |  |  | Uruguay
 |  |  |  |  | 145
 |  |  |  |  | Uzbekistan
 |  |  |  |  | 146
 |  |  |  |  | [NAME]
 |  |  |  |  | Venezuela
 |  |  |  |  | 147
 |  |  |  |  | Vietnam
 |  |  |  |  | 148
 |  |  |  |  | Württemberg*
 |  |  |  |  | Yemen
 |  |  |  |  | 149
 |  |  |  |  | Zambia
 |  |  |  |  | 150
 |  |  |  |  | Zimbabwe
 |  |  |  |  | 151
 |  |  |  |  | 152
 |  |  |  |  | 153
 |  |  |  |  | 154
 |  |  |  |  | 155
 |  |  |  |  | 156
 |  |  |  |  | 157
 |  |  |  |  | 158
 |  |  |  |  | 159
 |  |  |  |  | 160
 |  |  |  |  | 161
 |  |  |  |  | 162
 |  |  |  |  | 163
 |  |  |  |  | 164
 |  |  |  |  | 165
 |  |  |  |  | 166
 |  |  |  |  | 167
 |  |  |  |  | 168
 |  |  |  |  | 169
 |  |  |  |  | 170
 |  |  |  |  | 171
 |  |  |  |  | 172
 |  |  |  |  | 173
 |  |  |  |  | 174
 |  |  |  |  | 175
 |  |  |  |  | 176
 |  |  |  |  | 177
 |  |  |  |  | 178
 |  |  |  |  | 179
 |  |  |  |  | 180
 |  |  |  |  | 181
 |  |  |  |  | 182
 |  |  |  |  | 183
 |  |  |  |  | 184
 |  |  |  |  | 185
 |  |  |  |  | 186
 |  |  |  |  | 187
 |  |  |  |  | 188
 |  |  |  |  | 189
 |  |  |  |  | 190
 |  |  |  |  | 191
 |  |  |  |  | 192
 |  |  |  |  | 193
 |  |  |  |  | 194
 |  |  |  |  | 195
 |  |  |  |  | 196
 |  |  |  |  | 197
 |  |  |  |  | 198
 |  |  |  |  | 199
 |  |  |  |  | 200
 |  |  |  |  | 201
 |  |  |  |  | 202
 |  |  |  |  | 203
 |  |  |  |  | 204
 |  |  |  |  | 205
 |  |  |  |  | 206
 |  |  |  |  | 207
 |  |  |  |  | 208
 |  |  |  |  | 209
 |  |  |  |  | 210
 |  |  |  |  | 211
 |  |  |  |  | 212
 |  |  |  |  | 213
 |  |  |  |  | 214
 |  |  |  |  | 215
 |  |  |  |  | 216
 |  |  |  |  | 217
 |  |  |  |  | 218
 |  |  |  |  | 219
 |  |  |  |  | 220
 |  |  |  |  | 221
 |  |  |  |  | 222
 |  |  |  |  | 223
 |  |  |  |  | 224
 |  |  |  |  | 225
 |  |  |  |  | 226
 |  |  |  |  | 227
 |  |  |  |  | 228
 |  |  |  |  | 229
 |  |  |  |  | 230
 |  |  |  |  | 231
 |  |  |  |  | 232
 |  |  |  |  | 233
 |  |  |  |  | 234
 |  |  |  |  | 235
 |  |  |  |  | 236
 |  |  |  |  | 237
 |  |  |  |  | 238
 |  |  |  |  | 239
 |  |  |  |  | 240
 |  |  |  |  | 241
 |  |  |  |  | 242
 |  |  |  |  | 243
 |  |  |  |  | 244
 |  |  |  |  | 245
 |  |  |  |  | 246
 |  |  |  |  | 247
 |  |  |  |  | 248
 |  |  |  |  | 249
 |  |  |  |  | 250
 |  |  |  |  | 251
 |  |  |  |  | 252
 |  |  |  |  | 253
 |  |  |  |  | 254
 |  |  |  |  | 255
 |  |  |  |  | 256
 |  |  |  |  | 257
 |  |  |  |  | 258
 |  |  |  |  | 259
 |  |  |  |  | 260
 |  |  |  |  | 261
 |  |  |  |  | 262
 |  |  |  |  | 263
 |  |  |  |  | 264
 |  |  |  |  | 265
 |  |  |  |  | 266
 |  |  |  |  | 267
 |  |  |  |  | 268
 |  |  |  |  | 269
 |  |  |  |  | 270
 |  |  |  |  | 271
 |  |  |  |  | 272
 |  |  |  |  | 273
 |  |  |  |  | 274
 |  |  |  |  | 275
 |  |  |  |  | 276
 |  |  |  |  | 277
 |  |  |  |  | 278
 |  |  |  |  | 279
 |  |  |  |  | 280
 |  |  |  |  | 281
 |  |  |  |  | 282
 |  |  |  |  | 283
 |  |  |  |  | 284
 |  |  |  |  | 285
 |  |  |  |  | 286
 |  |  |  |  | 287
 |  |  |  |  | 288
 |  |  |  |  | 289
 |  |  |  |  | 290
 |  |  |  |  | 291
 |  |  |  |  | 292
 |  |  |  |  | 293
 |  |  |  |  | 294
 |  |  |  |  | 295
 |  |  |  |  | 296
 |  |  |  |  | 297
 |  |  |  |  | 298
 |  |  |  |  | 299
 |  |  |  |  | 300