Spreadsheet: 70289d1271085762-consolidating-data-into-one-cell-sample-data
Sheet: Starting Data

Data | Data2 | Description
SII001 | 123A01 | [NAME]
SII001 | 123A01 | Abu Dhabi
SII001 | 123A01 | Dubai
SII001 | 123A01 | [NAME]
SII001 | 123A01 | Luanda
SII001 | 123A01 | Soyo
SII001 | 123B01 | Luanda
SII001 | 123B01 | [NAME]
SII001 | 123B01 | Mendoza
SII001 | 123B01 | [NAME]
SII001 | 123B01 | Comodoro Rivadavia
SII001 | 123B01 | [NAME]
SII001 | 123B01 | Barrio Santa Genoveva
SII001 | 123B01 | Tartagal
SII002 | 123A02 | Tartagal
SII002 | 123A02 | [NAME]
SII002 | 123A02 | Baden
SII002 | 123A02 | Bentley
SII002 | 123A02 | Broome
SII002 | 123A02 | Dampier
SII002 | 123A02 | [NAME]
SII002 | 123A02 | Corio Quay
SII002 | 123A02 | Malaga
SII002 | 123A02 | Perth
SII002 | 123A02 | Baku
SII002 | 123A02 | Dhaka
SII002 | 123A02 | Nivelles
SII002 | 123A02 | Santa Cruz
SII002 | 123A02 | Aracaju
SII002 | 123B02 | Bahia
SII002 | 123B02 | [NAME]
SII002 | 123B02 | Botafogo
SII002 | 123B02 | [NAME]
SII002 | 123B02 | [NAME]
SII002 | 123B02 | Matriz
SII002 | 123B02 | Mossoro
SII002 | 123B02 | Para
SII002 | 123B02 | [NAME]
SII002 | 123B02 | Rio Grande Norte
SII003 | 123A03 | Salvador
SII003 | 123A03 | Sao Goncalo
SII003 | 123A03 | Sao Mateus
SII003 | 123A03 | Sao Paulo
SII003 | 123A03 | Serra
SII003 | 123A03 | [NAME]
SII003 | 123A03 | [NAME]
SII003 | 123A03 | Vitoria
SII003 | 123A03 | Catu
SII003 | 123A03 | Rio de Janeiro
SII003 | 123A03 | [NAME]
SII003 | 123A03 | Parauapebas
SII003 | 123A03 | [NAME]
SII003 | 123B03 | Rio de Janeiro
SII003 | 123B03 | Mossoro
SII003 | 123B03 | Airdrie
SII003 | 123B03 | Calgary
SII003 | 123B03 | Drayton Valley
SII003 | 123B03 | Grande Prairie
SII003 | 123B03 | Nisku
SII003 | 123B03 | Slave Lake
SII003 | 123B03 | Spruce Grove
SII003 | 123B03 | Whitecourt
SII004 | 123A04 | [NAME]
SII004 | 123A04 | [NAME]
SII004 | 123A04 | Dartmouth
SII004 | 123A04 | Weyburn
SII004 | 123A04 | Pointe-Noire
SII004 | 123A04 | Mies
SII004 | 123A04 | Abidjan
SII004 | 123A04 | Coquimbo
SII004 | 123A04 | Santiago
SII004 | 123A04 | Douala
SII004 | 123A04 | Beijing
SII004 | 123A04 | Minhang District Shanghai
SII004 | 123A04 | Shekou
SII004 | 123B04 | Shekou
SII004 | 123B04 | Tianjin
SII004 | 123B04 | 120000
SII004 | 123B04 | Arauca
SII004 | 123B04 | Yopal
SII004 | 123B04 | Bogota
SII004 | 123B04 | Neiva
SII004 | 123B04 | Bremen
SII005 | 123A05 | Celle
SII005 | 123A05 | Salzwedel
SII005 | 123A05 | Esbjerg
SII005 | 123A05 | Hvidovre
SII005 | 123A05 | [NAME]
SII005 | 123A05 | [NAME]
SII005 | 123A05 | [NAME]
SII005 | 123A05 | El Coca
SII005 | 123A05 | Quito
SII005 | 123A05 | [NAME]
SII005 | 123A05 | Cairo
SII005 | 123B05 | Cairo
SII005 | 123B05 | Barcelona
SII005 | 123B05 | Addis Ababa
SII005 | 123B05 | Helsinki
SII005 | 123B05 | Porvoo
SII005 | 123B05
SII005 | 123B05 | Billere
SII005 | 123B05 | [NAME]
SII005 | 123B05 | London
SII005 | 123B05 | Pocra Quay
SII005 | 123B05 | Aberdeen
SII006 | 123A06 | Aberdeen
SII006 | 123A06 | Peterhead
SII006 | 123A06 | [NAME]
SII006 | 123A06 | London
SII006 | 123A06 | Alton
SII006 | 123A06 | Basingstoke
SII006 | 123A06 | Morecambe
SII006 | 123A06 | Edinburgh
SII006 | 123A06 | Great Yarmouth
SII006 | 123B06 | Great Yarmouth
SII006 | 123B06 | Aberfeldy
SII006 | 123B06 | Stoke-On-Trent
SII006 | 123B06 | Accra
SII006 | 123B06 | Takoradi
SII006 | 123B06
SII006 | 123B06 | Luba
SII006 | 123B06 | Malabo
SII006 | 123B06 | Guatemala City
SII006 | 123B06 | [NAME]
SII006 | 123B06 | Budapest
SII006 | 123B06 | Balikpapan Selatan
SII006 | 123B06 | Balikpapan
SII006 | 123B06 | Balikpapen
SII007 | 123A07 | Batam
SII007 | 123A07 | Cikarang [NAME]
SII007 | 123A07 | Jakarta Selatan
SII007 | 123A07 | Jakarta Utara
SII007 | 123A07 | Jakarta
SII007 | 123A07 | Bombay Mumbai
SII007 | 123A07 | Coimbatore
SII007 | 123A07 | Maharashtra
SII007 | 123A07 | Mumbai
SII007 | 123A07 | Panoli
SII007 | 123A07
SII007 | 123A07 | Berra Ferrara
SII007 | 123B07 | [NAME]
SII007 | 123B07 | Milano
SII007 | 123B07 | Pisa
SII007 | 123B07 | [NAME]
SII007 | 123B07 | Trento
SII007 | 123B07 | Tokyo
SII007 | 123B07 | [NAME]
SII007 | 123B07 | [NAME]
SII007 | 123B07
SII007 | 123B07 | Aktau
SII007 | 123B07 | Aktobe
SII007 | 123B07 | Almaty
SII008 | 123A08 | Atyrau Oblast
SII008 | 123A08 | Atyrau
SII008 | 123A08 | Uralsk
SII008 | 123A08 | [NAME]
SII008 | 123A08 | Musrata
SII008 | 123A08 | Tripoli
SII008 | 123A08 | Rabat-Chellah
SII008 | 123A08 | Houston
SII008 | 123A08 | Yangon
SII008 | 123A08 | Colonia Granda
SII008 | 123A08 | Mexico City
SII008 | 123A08 | [NAME]
SII008 | 123B08 | Colonia Granada
SII008 | 123B08 | [NAME]
SII008 | 123B08 | Paraiso
SII008 | 123B08 | Villahermosa
SII008 | 123B08 | Reynosa
SII008 | 123B08 | [NAME]
SII008 | 123B08 | Veracruz
SII008 | 123B08 | Kemaman
SII008 | 123B08 | Kuala Lumpur
SII008 | 123B08 | Labuan FT
SII008 | 123B08
SII008 | 123B08 | Lagos
SII009 | 123A09 | Onne
SII009 | 123A09 | Port Harcourt
SII009 | 123A09 | Warri
SII009 | 123A09 | Heerhugowaard
SII009 | 123A09 | Holland
SII009 | 123A09 | Agotnes
SII009 | 123A09
SII009 | 123A09 | Bergen
SII009 | 123A09 | Floro
SII009 | 123A09 | [NAME]
SII009 | 123A09 | Kokstad
SII009 | 123A09 | Kristiansund
SII009 | 123A09 | Lillestrom
SII009 | 123B09 | Mongstad
SII009 | 123B09 | Porsgrunn
SII009 | 123B09 | Stavanger
SII009 | 123B09 | Stjordal
SII009 | 123B09 | Tananger
SII009 | 123B09 | Tjeldsto
SII009 | 123B09 | Torvastad
SII009 | 123B09 | New Plymouth
SII009 | 123B09 | Muscat
SII010 | 123A10 | Muscat
SII010 | 123A10
SII010 | 123A10 | Lima
SII010 | 123A10 | San Isidro
SII010 | 123A10 | Talara
SII010 | 123A10 | Trompeteros
SII010 | 123A10 | Salcedo Village, Makati City
SII010 | 123A10 | Karachi
SII010 | 123A10 | Doha
SII010 | 123A10 | Bucharest
SII010 | 123A10 | Ploiesti
SII010 | 123A10 | Buzuluk
SII010 | 123A10 | Gubkinsky
SII010 | 123A10 | Irkutsk
SII010 | 123B10 | [NAME]
SII010 | 123B10 | Krasnoyarsk
SII010 | 123B10 | Moscow
SII010 | 123B10 | Nefteyugansk
SII010 | 123B10 | Nizhnevartovsk
SII010 | 123B10 | Noviy Urengoy
SII010 | 123B10 | [NAME]
SII010 | 123B10 | [NAME]
SII010 | 123B10 | Surgut
SII010 | 123B10 | Tomsk
SII010 | 123B10 | Usinsk
SII010 | 123B10 | Volgograd
SII010 | 123B10 | Volzhsky
SII010 | 123B10 | Yuzhno-Sakhalinsk
SII010 | 123B10 | [NAME]
SII011 | 123A11 | [NAME]
SII011 | 123A11 | Dammam
SII011 | 123A11 | Saudi Arabia
SII011 | 123A11 | [NAME]
SII011 | 123A11 | Kharttoum
SII011 | 123A11 | Singapore
SII011 | 123A11 | Bangkok
SII011 | 123A11 | [NAME]
SII011 | 123A11 | [NAME]
SII011 | 123A11 | Turkmenbashi
SII011 | 123A11 | Tunis
SII011 | 123B11 | Zarzis
SII011 | 123B11
SII011 | 123B11 | [NAME]
SII011 | 123B11 | [NAME]
SII011 | 123B11 | [NAME]
SII011 | 123B11 | Port of Spain
SII011 | 123B11 | San Fernando
SII011 | 123B11 | Dar es Salaam
SII011 | 123B11 | Kiev
SII011 | 123B11 | Poltava
SII011 | 123B11 | Anchorage
SII011 | 123B11 | Alpine
SII012 | 123A12 | Deadhorse
SII012 | 123A12 | Fairbanks
SII012 | 123A12 | Nikiski
SII012 | 123A12 | Nuiqsut
SII012 | 123A12 | Prudhoe
SII012 | 123A12 | Brookwood
SII012 | 123A12 | Theodore
SII012 | 123A12 | Phoenix
SII012 | 123A12 | Tucson
SII012 | 123A12 | Bakersfield
SII012 | 123A12 | Culver
SII012 | 123A12 | Healdsburg
SII012 | 123B12 | Long Beach
SII012 | 123B12 | Los Angeles
SII012 | 123B12 | Oxnard
SII012 | 123B12 | Ventura
SII012 | 123B12 | Denver
SII012 | 123B12 | Englewood
SII012 | 123B12 | Grand Junction
SII012 | 123B12 | Piceance Creek
SII012 | 123B12 | Rangely
SII012 | 123B12 | Rifle
SII013 | 123A13 | Trinidad
SII013 | 123A13 | Macon
SII013 | 123A13 | Coffeyville
SII013 | 123A13 | Liberal
SII013 | 123A13 | Salina
SII013 | 123A13 | Florence
SII013 | 123A13 | Abbeville
SII013 | 123A13 | Amelia
SII013 | 123A13 | Baton Rouge
SII013 | 123A13 | Berwick
SII013 | 123A13 | Broussard
SII013 | 123A13 | Cameron
SII013 | 123A13 | Dulac
SII013 | 123A13 | Grand Isle
SII013 | 123B13 | Harvey
SII013 | 123B13 | North Hodge
SII013 | 123B13 | Intracoastal City
SII013 | 123B13 | Lafayette
SII013 | 123B13 | Lake Charles
SII013 | 123B13 | [NAME]
SII013 | 123B13 | Minden
SII013 | 123B13 | New Orleans
SII014 | 123A14 | [NAME]
SII014 | 123A14 | Port Fourchon
SII014 | 123A14 | Golden Meadow
SII014 | 123A14 | Scott
SII014 | 123A14 | Venice
SII014 | 123A14 | Westlake
SII014 | 123A14 | Youngsville
SII014 | 123A14 | Chesterfield
SII014 | 123A14 | Kansas City
SII014 | 123A14 | Laurel
SII014 | 123A14 | Waynesboro
SII014 | 123A14 | Roundup
SII014 | 123A14 | Shelby
SII014 | 123A14 | New Bern
SII014 | 123B14
SII014 | 123B14 | Dickinson
SII014 | 123B14 | Stanley
SII014 | 123B14 | Williston
SII014 | 123B14 | Bloomfield
SII014 | 123B14 | Farmington
SII014 | 123B14 | Hobbs
SII014 | 123B14 | Battle Mountain
SII014 | 123B14 | Carlin
SII014 | 123B14 | Antlers
SII014 | 123B14 | Ardmore
SII015 | 123A15 | [NAME]
SII015 | 123A15 | Chickasha
SII015 | 123A15 | Cyril
SII015 | 123A15 | Elk City
SII015 | 123A15 | Eufaula
SII015 | 123A15 | Oklahoma City
SII015 | 123A15 | Ponca City
SII015 | 123A15 | Canonsburg
SII015 | 123A15 | Williamsport
SII015 | 123A15 | Abilene
SII015 | 123A15 | Aledo
SII015 | 123B15 | [NAME]
SII015 | 123B15 | Alvarado
SII015 | 123B15 | Alvin
SII015 | 123B15 | [NAME]
SII015 | 123B15 | Azle
SII015 | 123B15 | Beeville
SII015 | 123B15 | Brownsville
SII015 | 123B15 | [NAME]
SII015 | 123B15 | Canadian
SII015 | 123B15 | Corpus Christi
SII015 | 123B15 | Dallas
SII015 | 123B15 | Denver City
SII015 | 123B15 | Edinburg
SII016 | 123A16 | Edinburg
SII016 | 123A16 | Edna
SII016 | 123A16 | Franklin
SII016 | 123A16 | Freeport
SII016 | 123A16 | Galena Park
SII016 | 123A16 | Galveston
SII016 | 123A16 | Hebbronville
SII016 | 123A16 | Houston
SII016 | 123A16 | Stafford
SII016 | 123B16 | Houston
SII016 | 123B16 | Hungerford
SII016 | 123B16 | Kilgore
SII016 | 123B16 | Liberty
SII016 | 123B16 | Madisonville
SII016 | 123B16 | Midland
SII016 | 123B16 | Millsap
SII016 | 123B16 | Navasota
SII016 | 123B16 | Odessa
SII016 | 123B16 | Palestine
SII017 | 123A17 | Pearland
SII017 | 123A17 | Pecos
SII017 | 123A17 | Perryton
SII017 | 123A17 | [NAME]
SII017 | 123A17 | Port O'Connor
SII017 | 123A17 | San Antonio
SII017 | 123A17 | Shamrock
SII017 | 123A17 | Silsbee
SII017 | 123A17 | Telingua
SII017 | 123A17 | Tyler
SII017 | 123A17 | [NAME]
SII017 | 123A17 | Zavalla
SII017 | 123A17 | Bluff
SII017 | 123A17 | Myton
SII017 | 123A17 | Appleton
SII017 | 123A17 | Buckhannon
SII017 | 123B17 | Buckhannon
SII017 | 123B17 | Bairoil
SII017 | 123B17 | Big Piney
SII017 | 123B17 | Casper
SII017 | 123B17 | Evanston
SII017 | 123B17 | Granger
SII017 | 123B17 | [NAME]
SII017 | 123B17 | [NAME]
SII017 | 123B17 | Riverton
SII017 | 123B17 | Rock Springs
SII018 | 123A18 | Rock Springs
SII018 | 123A18 | Wamsutter
SII018 | 123A18 | Guiria
SII018 | 123A18 | [NAME]
SII018 | 123A18 | Anaco
SII018 | 123A18 | Barcelona
SII018 | 123A18 | El Tigre
SII018 | 123A18 | [NAME]
SII018 | 123A18 | [NAME]
SII018 | 123A18 | Caracas
SII018 | 123B18 | Maturin
SII018 | 123B18 | [NAME]
SII018 | 123B18 | Guiria
SII018 | 123B18 | Ciudad Ojeda
SII018 | 123B18 | [NAME]
SII018 | 123B18 | [NAME]
SII018 | 123B18 | [NAME]
SII018 | 123B18 | Hodeidah
SII018 | 123B18 | Masila
SII018 | 123B18 | Sanaa
SII018 | 123B18 | Cape Town