Spreadsheet: 163460d1340310840-match-same-data-from-diff-columns-and-group-them-under-unique-values-sample
Sheet: Sheet1

COUNTRY | PORT GROUP | NEW              KEY PORT GROUPS |  | B | D1 | D2 | E1 | E2 | E3 | E4 | F | F PRICE product  1 | F PRICE product  2
[NAME], U.S. | ST. CROIX |  |  | MONTREAL | MONTREAL | CRISTOBAL | SINGAPORE | NANJING | ISTANBUL | KANDLA | MONTREAL | 34 | 54
VIET NAM | VIETNAM |  |  | PIRAEUS | PIRAEUS | FUJAIRAH | [NAME] | QINGDAO | BAHRAIN | CALCUTTA | PIRAEUS | 36 | 56
VENEZUELA | MARACAIBO |  |  | SINGAPORE | SINGAPORE | RICHARDS BAY | BUENOS AIRES | DALIAN | PARANAGUA | CHENNAI | SINGAPORE | 34 | 54
VENEZUELA | PUERTO CABELLO |  |  | [NAME] | [NAME] | CAPE TOWN | SHANGHAI | NANTONG | INCHON | VISAKAPATNAM | [NAME] | 35 | 55
VENEZUELA | PUERTO LA CRUZ |  |  | BUENOS AIRES | BUENOS AIRES | GUANGZHOU | DURBAN | [NAME] | TARRAGONA | RIO GRANDE | BUENOS AIRES | 40 | 60
VENEZUELA | PUERTO ORDAZ |  |  | SHANGHAI | SHANGHAI | NANJING | SUEZ | TIANJIN | HUELVA | SALVADOR | SHANGHAI | 40 | 60
URUGUAY | MONTEVIDEO |  |  | DURBAN | DURBAN | QINGDAO | GIBRALTAR | HAMBURG | MUMBAI | [NAME] | DURBAN | 40 | 60
UNITED STATES | ANCHORAGE, AK |  |  | SUEZ | SUEZ | DALIAN | ANTWERP | ALGECIRAS |  | NANJING | SUEZ | 36 | 56
UNITED STATES | BALTIMORE |  |  | GIBRALTAR | GIBRALTAR | NANTONG | PORT SAID | PUSAN |  | HOUSTON | GIBRALTAR | 36 | 56
UNITED STATES | BEAUMONT |  |  | ANTWERP | ANTWERP | [NAME] | CRISTOBAL | CORPUS CRISTI |  |  | ANTWERP | 36 | 56
UNITED STATES | BOSTON, MA |  |  | PORT SAID | PORT SAID | TIANJIN | FUJAIRAH |  |  |  | PORT SAID | 35 | 55
UNITED STATES | CHARLESTON |  |  | CRISTOBAL | NEW YORK | HAMBURG | RICHARDS BAY |  |  |  | CRISTOBAL | 34 | 54
UNITED STATES | CORPUS CHRISTI | 3 |  | FUJAIRAH | CRISTOBAL | ALGECIRAS | CAPE TOWN |  |  |  | FUJAIRAH | 40 | 60
UNITED STATES | FREEPORT, TX |  |  | RICHARDS BAY | FUJAIRAH | PUSAN | GUANGZHOU |  |  |  | RICHARDS BAY | 36 | 56
UNITED STATES | HONOLULU |  |  | CAPE TOWN | RICHARDS BAY | ISTANBUL |  |  |  |  | CAPE TOWN | 34 | 54
UNITED STATES | HOUSTON | 1 |  | GUANGZHOU | CAPE TOWN | BAHRAIN |  |  |  |  | GUANGZHOU | 34 | 54
UNITED STATES | JACKSONVILLE |  |  | NANJING | GUANGZHOU | PARANAGUA |  |  |  |  | NANJING | 34 | 54
UNITED STATES | LOS ANGELES |  |  | QINGDAO | NANJING | INCHON |  |  |  |  | QINGDAO | 34 | 54
UNITED STATES | MIAMI |  |  | DALIAN | QINGDAO | TARRAGONA |  |  |  |  | DALIAN | 35 | 55
UNITED STATES | MOBILE |  |  | NANTONG | DALIAN | HUELVA |  |  |  |  | NANTONG | 35 | 55
UNITED STATES | NEW HAVEN, CT |  |  | [NAME] | NANTONG | HOUSTON |  |  |  |  | [NAME] | 35 | 55
UNITED STATES | NEW ORLEANS |  |  | TIANJIN | [NAME] |  |  |  |  |  | TIANJIN | 35 | 55
UNITED STATES | NEW YORK | 4 |  | HAMBURG | CORPUS CRISTI |  |  |  |  |  | HAMBURG | 36 | 56
UNITED STATES | NORFOLK, VA |  |  | ALGECIRAS |  |  |  |  |  |  | ALGECIRAS | 37 | 57
UNITED STATES | PHILADELPHIA |  |  | PUSAN |  |  |  |  |  |  | PUSAN | 38 | 58
UNITED STATES | PORT CANAVERAL, FL |  |  | ISTANBUL |  |  |  |  |  |  | ISTANBUL | 39 | 59
UNITED STATES | PORTLAND, ME |  |  | BAHRAIN |  |  |  |  |  |  | BAHRAIN | 35 | 55
UNITED STATES | PORTLAND, OR |  |  | PARANAGUA |  |  |  |  |  |  | PARANAGUA | 35 | 55
UNITED STATES | SAN FRANCISCO |  |  | INCHON |  |  |  |  |  |  | INCHON | 36 | 56
UNITED STATES | SAVANNAH |  |  | TARRAGONA |  |  |  |  |  |  | TARRAGONA | 36 | 56
UNITED STATES | SEATTLE, WA |  |  | HUELVA |  |  |  |  |  |  | HUELVA | 35 | 55
UNITED STATES | TAMPA, FL |  |  | MUMBAI |  |  |  |  |  |  | MUMBAI | 36 | 56
UNITED STATES | WILMINGTON, NC |  |  | KANDLA |  |  |  |  |  |  | KANDLA | 36 | 56
UNITED KINGDOM | ABERDEEN |  |  | CALCUTTA |  |  |  |  |  |  | CALCUTTA | 36 | 56
UNITED KINGDOM | BELFAST |  |  | CHENNAI |  |  |  |  |  |  | CHENNAI | 36 | 56
UNITED KINGDOM | CARDIFF |  |  | VISAKAPATNAM
UNITED KINGDOM | FALMOUTH |  |  | RIO GRANDE
UNITED KINGDOM | GLASGOW/EDINBURGH |  |  | SALVADOR
UNITED KINGDOM | GREAT YARMOUTH |  |  | [NAME]
UNITED KINGDOM | HULL |  |  | NANJING
UNITED KINGDOM | LIVERPOOL |  |  | HOUSTON
UNITED KINGDOM | MIDDLESBROUGH |  |  | CORPUS CRISTI
UNITED KINGDOM | MILFORD HAVEN
UNITED KINGDOM | NEWCASTLE-UPON-TYNE
UNITED KINGDOM | SHETLAND
UNITED KINGDOM | SOUTHAMPTON
UNITED KINGDOM | TILBURY
UNITED ARAB EMIRATES | ABU DHABI
UNITED ARAB EMIRATES | DUBAI
UNITED ARAB EMIRATES | FUJAIRAH
UKRAINE | ODESSA
TURKEY | ISTANBUL | 2
TUNISIA | RADES
TRINIDAD AND TOBAGO | PORT OF SPAIN
THAILAND | BANGKOK
TAIWAN, REPUBLIC OF CHINA | KAOHSIUNG
TAIWAN, REPUBLIC OF CHINA | KEELUNG
SYRIAN ARAB REPUBLIC | [NAME]
SWEDEN | GOTHENBURG
SWEDEN | HALMSTAD
SWEDEN | [NAME]
SWEDEN | KOEPING
SWEDEN | LULEAA
SWEDEN | LYSEKIL
SWEDEN | MALMOE
SWEDEN | NORRKOEPING
SWEDEN | STOCKHOLM
SWEDEN | STROMSTAD
SWEDEN | SUNDSVALL
SRI LANKA | COLOMBO
SPAIN | ALGECIRAS
SPAIN | BARCELONA
SPAIN | BILBAO
SPAIN | CADIZ
SPAIN | CARTAGENA
SPAIN | CEUTA
SPAIN | GIJON
SPAIN | HUELVA
SPAIN | LA CORUNA
SPAIN | LAS PALMAS
SPAIN | TARRAGONA
SPAIN | TENERIFE
SPAIN | VALENCIA
SPAIN | VIGO
SOUTH AFRICA | CAPE TOWN
SOUTH AFRICA | DURBAN
SOUTH AFRICA | EAST LONDON
SOUTH AFRICA | PORT [NAME]
SOUTH AFRICA | RICHARDS BAY
SOUTH AFRICA | SALDANHA BAY
SINGAPORE | SINGAPORE
SENEGAL | DAKAR
SAUDI ARABIA | DAMMAM
SAUDI ARABIA | JEDDAH
RUSSIAN FEDERATION | MURMANSK
RUSSIAN FEDERATION | NOVOROSSIYSK
RUSSIAN FEDERATION | ST.PETERSBURG
RUSSIAN FEDERATION | VLADIVOSTOK
ROMANIA | CONSTANTA
QATAR | QATAR
PUERTO RICO | SAN JUAN
PORTUGAL | AZORES
PORTUGAL | LEIXOES
PORTUGAL | LISBON
PORTUGAL | SETUBAL
PORTUGAL | SINES
POLAND | GDANSK
POLAND | SZCZECIN
PHILIPPINES | [NAME]
PHILIPPINES | MANILA
PERU | CALLAO
PANAMA | CRISTOBAL
PAKISTAN | KARACHI
OMAN | OMAN
NORWAY | AALESUND
NORWAY | BERGEN
NORWAY | FARSUND
NORWAY | HARSTAD
NORWAY | HAUGESUND
NORWAY | KIRKENES
NORWAY | [NAME]
NORWAY | KRISTIANSUND
NORWAY | LARVIK
NORWAY | OSLO
NORWAY | PORSGRUNN
NORWAY | STAVANGER
NORWAY | TROMSOE
NIGERIA | LAGOS
NEW ZEALAND | AUCKLAND
NETHERLANDS ANTILLES | CURACAO
NETHERLANDS | AMSTERDAM
NETHERLANDS | DELFZIJL
NETHERLANDS | [NAME]
NETHERLANDS | TERNEUZEN
NETHERLANDS | VLISSINGEN
NAMIBIA | WALVIS BAY
MOROCCO | CASABLANCA
MEXICO | VERA CRUZ
MALTA | MALTA
MALAYSIA | LABUAN
MALAYSIA | PASIR GUDANG
MALAYSIA | PENANG
MALAYSIA | PORT KELANG
LITHUANIA | KLAIPEDA
LEBANON | BEIRUT
LATVIA | RIGA
KUWAIT | KUWAIT
KOREA, REPUBLIC OF | INCHON
KOREA, REPUBLIC OF | PUSAN
JAPAN | KOBE
JAPAN | MOJI
JAPAN | YOKOHAMA
IVORY COAST | ABIDJAN
ITALY | AUGUSTA
ITALY | BARI
ITALY | CIVITAVECCHIA
ITALY | GENOA
ITALY | LIVORNO
ITALY | NAPOLI
ITALY | [NAME]
ITALY | TRIESTE
ITALY | VENEZIA
IRELAND | CORK
IRELAND | DUBLIN
INDONESIA | JAKARTA
INDIA | CALCUTTA
INDIA | CHENNAI
INDIA | KANDLA
INDIA | MUMBAI
INDIA | VISAKHAPATNAM
ICELAND | REYKJAVIK
HONG KONG | HONG KONG
GUAM | GUAM
GREECE | PIRAEUS
GIBRALTAR | GIBRALTAR
GERMANY | BREMEN
GERMANY | EMDEN
GERMANY | HAMBURG
GERMANY | [NAME]
GERMANY | ROSTOCK
GERMANY | WILHELMSHAVEN
FRENCH POLYNESIA | TAHITI
FRANCE | BORDEAUX
FRANCE | BREST
FRANCE | DUNKIRK
FRANCE | LA PALLICE
FRANCE | LE HAVRE
FRANCE | [NAME]
FRANCE | [NAME]
FINLAND | HELSINKI
FINLAND | KOTKA
FINLAND | TURKU
FINLAND | VAASA
ESTONIA | TALLINN
EGYPT | ALEXANDRIA
EGYPT | PORT SAID
EGYPT | SUEZ
ECUADOR | GUAYAQUIL
DENMARK | AARHUS
DENMARK | COPENHAGEN
DENMARK | ESBJERG
DENMARK | KALUNDBORG
CYPRUS | LIMASSOL
CUBA | HAVANA
CROATIA | RIJEKA
CONGO | POINTE NOIRE
CHINA | DALIAN
CHINA | GUANGZHOU
CHINA | NANJING
CHINA | NANTONG
CHINA | [NAME]
CHINA | QINGDAO
CHINA | SHANGHAI
CHINA | TIANJIN
CHILE | VALPARAISO
CANADA | HALIFAX
CANADA | MONTREAL
CANADA | ST. JOHNS, NFLD
CANADA | [NAME]
BULGARIA | BURGAS
BULGARIA | VARNA
BRAZIL | BELEM
BRAZIL | FORTALEZA
BRAZIL | ITAJAI
BRAZIL | [NAME]
BRAZIL | PARANAGUA
BRAZIL | RECIFE
BRAZIL | RIO DE JANEIRO
BRAZIL | RIO GRANDE
BRAZIL | SALVADOR
BRAZIL | SANTOS
BRAZIL | SAO LUIZ
BRAZIL | VITORIA
BELGIUM | ANTWERP
BELGIUM | GHENT
BELGIUM | ZEEBRUGGE
BARBADOS | BARBADOS
BANGLADESH | CHITTAGONG
BAHRAIN | BAHRAIN
BAHAMAS | FREEPORT, BAHAMAS
AUSTRALIA | ADELAIDE
AUSTRALIA | BRISBANE
AUSTRALIA | DAMPIER
AUSTRALIA | DARWIN
AUSTRALIA | FREMANTLE
AUSTRALIA | MELBOURNE
AUSTRALIA | SYDNEY
AUSTRALIA | TOWNSVILLE
ARGENTINA | BAHIA BLANCA
ARGENTINA | BUENOS AIRES
ARGENTINA | NECOCHEA
ARGENTINA | ROSARIO
ARGENTINA | USHUAIA