Spreadsheet: 725875d1616937866-compiling-values-from-5-columns-into-a-new-column-upload-test
Sheet: Sheet1

I would like everything here
 |  | Gambia
 |  | Poland
 |  | [NAME]
 |  | Norway
 |  |  |  |  |  |  |  | <<#- Sample of where I deleted the column and the concat breaks
 |  | Ceuta
 |  | Great Britain
 |  | Germany
 |  | Azerbaijan
 |  | Libya
 |  | Malaysia
 |  | India
 |  | Zambia
 |  | Syria Arab Republic
 |  | Azerbaijan
 |  |  |  |  | Australia
 |  |  |  |  | Zambia
 |  |  |  |  | Mauritania
 |  |  |  |  | Brazil
 |  |  |  |  | Ireland
 |  |  |  |  | Switzerland
 |  |  |  |  | Great Britain
 |  |  |  |  | Belize
 |  |  |  |  | Honduras
 |  |  |  |  | Ghana
 |  |  |  |  | Lithuania
 |  |  |  |  | Cambodia
 |  |  |  |  | Lithuania
 |  |  |  |  | Philippines
 |  |  |  |  | Russia Federation
 |  |  |  |  | Hungary
 | South Africa
 | Oman
 | Afghanistan
 | Ireland
 | Algeria
 | Iran, Islamic Republic of
 | Lebanon
 | United States
 | Lebanon
 | Seychelles
 | Estonia
 | Canada
 | Northern Ireland
 | Czech Republic
 | Great Britain
 | India
 | Hungary
 |  |  | Viet Nam
 |  |  | Great Britain
 |  |  | Bahrain
 |  |  | Malaysia
 |  |  | Egypt
 |  |  | Cocos Islands(or Keeling Islands)
 |  |  | Qatar
 |  |  | Egypt
 |  |  | Cote d'Ivoire
 |  |  | China
 |  |  | Guinea
 |  |  | Jordan
 |  |  | Finland
 |  |  | Japan
 |  |  | Venezuela, Bolivarian republic of
 |  |  | Unknown (Non-EU)
 |  |  | Japan
 |  |  | Austria
 |  |  | Thailand
 |  |  | Turkey
 |  |  | Nicaragua
 |  |  | Chad
 |  |  | Great Britain
 |  |  | Kazakhstan
 |  |  | Israel
 |  |  | Sweden
 |  |  | Cyprus
 |  |  | Argentina
 |  |  | [NAME]
 |  |  | Unknown (Non-EU)
 |  |  | [NAME]
 |  |  | Guinea
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Bahrain
 |  |  | Ireland
 |  |  | New Zealand
 |  |  | United States
 |  |  | [NAME]
 |  |  | Poland
 |  |  | Hong Kong
 |  |  | Kenya
 |  |  | Algeria
 |  |  | Lithuania
 |  |  | Taiwan
 |  |  | Algeria
 |  |  | Cameroon
 |  |  | Iraq
 |  |  | South Africa
 |  |  | Senegal
 |  |  | Jordan
 |  |  | Azerbaijan
 |  |  | Colombia
 |  |  | [NAME]
 |  |  | Italy
 |  |  | Uruguay
 |  |  | Luxembourg
 |  |  | Venezuela, Bolivarian republic of
 |  |  | [NAME]
 |  |  | Netherlands
 |  |  | Singapore
 |  |  | Austria
 |  |  | South Africa
 |  |  | Denmark
 |  |  | China
 |  |  | Germany
 |  |  | Ireland
 |  |  | Austria
 |  |  | Japan
 |  |  |  | Peru
 |  |  |  | Ukraine
 |  |  |  | Slovakia
 |  |  |  | Cote d'Ivoire
 |  |  |  | Mexico
 |  |  |  | Nigeria
 |  |  |  | Bolivia, Plurinational State of
 |  |  |  | Equatorial Guinea
 |  |  |  | Canada
 |  |  |  | Angola
 |  |  |  | Netherlands
 |  |  |  | Japan
 |  |  |  | Netherlands
 |  |  |  | Pakistan
 |  |  |  | Poland
 |  |  |  | Switzerland
 |  |  |  | Congo
 |  |  |  | Northern Mariana Islands
 |  |  |  | Taiwan
 |  |  |  | Morocco
 |  |  | Azerbaijan
 |  |  | Algeria
 |  |  | Greece
 |  |  | Bosnia and Herzegovina
 |  |  | Estonia
 |  |  | Ireland
 |  |  | Seychelles
 |  |  | United States
 |  |  | Gabon
 |  |  | Pakistan
 |  |  | Faroe Islands
 |  |  | [NAME]
 |  |  | Moldova, Republic of
 |  |  | Cyprus
 |  |  | Lebanon
 |  |  | Malaysia
 |  |  | Syria Arab Republic
 |  |  | Netherlands
 |  |  | South Korea
 | Madagascar
 | Japan
 | Russia Federation
 | Saudi Arabia
 | Gabon
 | Latvia
 | Afghanistan
 | Cote d'Ivoire
 | Hong Kong
 | Slovakia
 | Yemen
 | Georgia
 |  |  |  | Bangladesh
 |  |  |  | Brazil
 |  |  |  | [NAME]
 |  |  |  | Mexico
 |  |  |  | Bosnia and Herzegovina
 |  |  |  | Singapore
 |  |  |  | Panama
 |  |  |  | Turkey
 |  |  |  | Belgium
 |  |  |  | United States
 |  |  |  | Indonesia
 |  |  |  | Dominica
 |  |  |  | Kuwait
 |  |  |  | Sweden
 | Mongolia
 | Czech Republic
 | Russia Federation
 | Ceuta
 | Estonia
 | Great Britain
 | Malaysia
 | Ghana
 | China
 | Nicaragua
 | Qatar
 | Senegal
 | Turkey
 | Canada
 | Uruguay
 | Zambia
 | China
 | Oman
 |  | [NAME]
 |  | Hong Kong
 |  | Saudi Arabia
 |  | Belgium
 |  | Romania
 |  | Kenya
 |  | Portugal
 |  | Malaysia
 |  | Canada
 |  | Great Britain
 |  | France
 |  | Turkey
 |  | Thailand
 |  | Slovenia
 | United States
 | Bulgaria
 | Egypt
 | Guinea
 | [NAME]
 | Mexico
 | Norway
 | Uganda
 | Djibouti
 | Lithuania
 | France
 | Switzerland
 | Unknown (Intra EU)
 | South Africa
 | Fiji
 | Croatia
 | Malta
 | Israel
 | South Korea
 | Poland
 | Australia
 |  |  | Serbia
 |  |  | Colombia
 |  |  | France
 |  |  | New Zealand
 |  |  | Bahrain
 |  |  | Yemen
 |  |  | Ukraine
 |  |  | Estonia
 |  |  | Grenada
 |  |  | Germany
 |  |  | Guatemala
 |  |  | Grenada
 |  |  | Germany
 |  |  | Paraguay
 |  |  | China
 |  |  | Lithuania
 |  |  | Gibraltar
 |  |  | Canada
 | Argentina
 | Viet Nam
 | New Zealand
 | Iran, Islamic Republic of
 | Northern Ireland
 | Singapore
 | Spain
 | Singapore
 | Ukraine
 | Ukraine
 | Brazil
 | [NAME]
 | Netherlands
 | Croatia
 | Great Britain
 | South Africa
 | Cambodia
 | [NAME]
 | [NAME]
 | Sweden
 | Libya
 | Kazakhstan
 | Poland
 | Morocco
 | Ireland
 | Tunisia
 | Slovakia
 | Georgia
 | Colombia
 | Ireland
 | Angola
 | Lithuania
 | Switzerland
 | Turkey
 | Denmark
 | Croatia
 | China
 | Netherlands
 | Bosnia and Herzegovina
 | Hong Kong
 | Bahamas
 | Czech Republic
 | Dominican Republic
 | Uganda
 | India
 |  |  |  | Unknown (Non-EU)
 |  |  |  | Thailand
 |  |  |  | United Arab Emirates
 |  |  |  | Syria Arab Republic
 |  |  |  | Turkey
 |  |  |  | Bangladesh
 |  |  |  | South Korea
 |  |  |  | Singapore
 |  |  |  | Bangladesh
 |  |  |  | South Africa
 |  |  |  | Saudi Arabia
 |  |  |  | Luxembourg
 |  |  |  | [NAME]
 |  |  |  | Kuwait
 |  |  |  | Haiti
 | China
 | Singapore
 | Togo
 | India
 | Saudi Arabia
 | Finland
 | [NAME] and [NAME]
 | Australia
 | Poland
 | Turkey
 | Great Britain
 | Northern Ireland
 | Aruba
 | Egypt
 | Equatorial Guinea
 | Gabon
 | United States Minor Outlying Islands
 | Poland
 | Japan
 | Albania