Spreadsheet: 177959d1346561605-macro-excel-merge-data-from-multiple-cell-rows-into-single-cell-sample
Sheet: after

NO | Unit | Group
1 | A.F.P. UNION VIDA S.A.
2 | A.F.S.K. INDUSTRIES LTD. | A.F.S.K. INTERNATIONAL B.V.
3 | [NAME] | BARR LEASING LIMITED,  FINDLAY'S LIMITED,  TAUT (UK) LIMITED,  RUBICON DRINKS LIMITED,  GROUPE RUBICON LTD,  HAMPSHIRE MINERAL WATER COMPANY LIMITED(THE),  MANDORA ST. CLEMENTS LIMITED,  [NAME],  ST CLEMENTS (UK) LIMITED,  TIZER LIMITED
4 | A.G. EDWARDS INC
5 | [NAME] (NIGERIA) PLC
6 | A.G. PETZETAKIS S.A. | A.G. PETZETAKIS ROMANIA SRL,  EUROHOSE LTD,  FLEXIPLAS S.A.,  INDUPLAS S.P.A.,  KAVALA PLASTICS S.A.,  MILLENIUM HOLDINGS LTD, PETZETAKIS A. GMBH,  PETZETAKIS A.G. INTERNATIONAL HOLDINGS LTD,  PETZETAKIS VOREIOU ELLADOS S.A.,  EUROHOSE LIMITED,  PETZETAKIS NORTHERN GREECE S.A.,
7 | A.G.D. MINING LIMITED
8 | A.I.S AG
9 | A.I.S. RESOURCES LIMITED
10 | [NAME] PCL
11 | A.K. CAPITAL SERVICES LTD.
12 | A.L. PROCHOICE GROUP PUBLIC LIMITED | CPI HOLDINGS PUBLIC LTD, LORDOS UNITED PLASTICS PUBLIC LTD
13 | A.L.D. ADVANCED LOGISTICS DEVELOPMENTS LTD.
14 | A.LEVI INVESTMENT & CONSTRUCTION LTD. | EURO GLOBE LIMITED
15 | A.P. MÖLLER -  A/S | [NAME] A/S  AVIATION HOLDING A/S ROULUNDS FABRIKER ANCHOR TRANSPORT CORPORATION AP MOLLER (BERMUDA) LTD AP MOLLER SINGAPORE PTE LTD APM GLOBAL LOGISTICS (SHANGHAI) CO., LTD. APM PIPELINES A/S  DALIAN COMPANY LIMITED  INTERNATIONAL BV  ITAJAÍ PARTICIPAÇÕES LTDA.  JAPAN [NAME] LLC  MEXICO SA DE CV  SAO PAULO PARTICIPACOES LTDA  SHANGHAI CO LTD  TAIWAN CO LTD  TIANJIN INTERNATIONAL CO LTD  XIAMEN COMPANY LTD  YANGSHAN CO LTD BARKENTINE INSURANCE COMPANY LIMITED BERMUTINE TRANSPORT CORPORATION LIMITED BRIGANTINE SERVICES LIMITED CONSTAR HOLDING CO LTD CORVERTINE INSURANCE COMPANY LIMITED DSL STAR EXPRESS EGYPTIAN INTERNATIONAL CONTAINER TERMINAL SA EJENDOMSSELSKABET LINDØ A/S HOLDINGSELSKABET AF 19. MARTS 2010 A/S INTERSEAS SHIPPING COMPANY SA LIVE OAK COMPANY LIMITED LNG 1 A/S LNG 2 A/S  (CHINA) LIMITED  A/S  AUSTRALIA PTY LTD  BAHAMAS LTD  BANGLADESH LIMITED  BEOGRAD DOO  BULGARIA LIMITED EOOD  BURUNDI SA  CAMBODIA LTD  CHILE S.A.  CONGO RDC SPRL  CONTAINER INDUSTRI DONGGUAN LTD  CONTAINER INDUSTRY A/S  CURLEW A/S  CYPRUS LTD  DE NICARAGUA SA  DEUTSCHLAND A/S & CO. KG  DOMINICANA S.A.  DRILLING SERVICES A/S  EL SALVADOR S.A. DE C.V.  ETHIOPIA PRIVATE LTD COMPANY  FPSOS A/S  GAMBIA LIMITED  GLOBAL SERVICE CENTRES (GUANGDONG) LTD  GLOBAL SERVICE CENTRES (PHILLIPINES) LTD  GUATEMALA, S.A.  HELLAS SHIPPING SA  HONDURAS S.A.  INDIA PVT. LTD.  JSC  JUPITER DRILLING CORPORATION SA  [NAME] HOLDING A/S  LNG A/S  LOGISTICS HONG KONG LTD  MACAU LDA  NIGER SA  PANAMA S.A.  PERU S.A.  QATAR MARITIME SERVICE  RWANDA LIMITED  SHIPPING HONG KONG LTD  SOUTH AFRICA (PTY) LTD  SOUTH AMERICA LTD.  SUPPLY SERVICE A/S  TRINIDAD LIMITED  TRUCKING (CHINA) CO LTD  URUGUAY S.A. MÆRSK INDUSTRI A/S MÆRSK OLIE OG GAS A/S MCC TRANSPORT SINGAPORE PTE. LTD. MEMBRANE SHIPPING LIMITED NORSE MERCHANT GROUP LTD ODENSE STAALSKIBSVÆRFT A/S PRODUCTTANKERS AB PT APM GLOBAL LOGISTICS INDONESIA PT  INDONESIA REDERIAKTIESELSKABET KULING ROULUNDS HOLDING A/S SUNRISE 1 A/S SVITZER A/S TRANS-SIBERIAN EXPRESS SERVICE OOO TRANSPORTE MARITIMO  VENEZUELA S.A. APM HOLDINGS AUSTRALIA PTY LTD APM TERMINAL PARTICIPACOES LTDA  A/S  ALGECIRAS SA  MAASVLAKTE II B.V.  MANAGEMENT B.V.  NORTH AMERICA, I  PACIFIC LTD.  ROMANIA SRL  ZEEBRUGGE BRIDGE TERMINAL TRANSPORT CANADA INC BRIDGE TERMINAL TRANSPORT, INC. DAMCO A/S DAMCO DENMARK A/S DAMCO GERMANY GMBH DAMCO INTERNATIONAL B.V. DAMCO NETHERLANDS B.V. DAMCO SWEDEN AB DAMCO USA INC. DANIA TRUCKING A/S DFDS LOGISTICS B.V. ERS RAILWAYS B.V. EUROPEAN RAIL SHUTTLE B.V. FUTE  AGENCY LOKSA SHIPYARD LTD M POLAND SP. Z O.O. W LIKWIDACJI  (ANGOLA) LDA  (MALAWI) LIMITED  ADRIA DOO  AGENCY DENMARK A/S  ALGERIE SPA  ARGENTINA S.A.  BAHRAIN A/S  BENELUX B.V.  BENIN  S A  BRASIL (BRASMAR) LTDA.  BURKINA FASO SA  CENTRAL AMERICA AND CARIBBEAN LIMITED  COMPANY CANADA LIMITED  COMPANY LIMITED(THE)  CONGO SA  COSTA RICA SA  COTE D'IVOIRE SA  CROATIA DOO  CUSTOMS SERVICES INC.  CZECH REPUBLIC, S.R.O.  DENIZCILIK AS  DISTRIBUTION CANADA INC  DISTRIBUTION SERVICES INC.  DRILLING NORGE AS  EASTERN EUROPE APS  EESTI AS  EGYPT FOR MARITIME TRANSPORT (SAE)  ENERGY UK LTD.  EQUIPMENT SERVICE COMPANY, INC.  FINLAND OY  FLUID TECHNOLOGY, INC.  FRANCE  GEORGIA LLC  GHANA LTD  GLOBAL SERVICE CENTRE (SHENZHEN)  GLOBAL SERVICE CENTRES (INDIA) PRIVATE LTD  GLOBAL SERVICES CENTRE COSTA RICA S.A.  GUINEE SA  HOLDINGS LIMITED  HONG KONG LIMITED  HUNGARY HAJÓZÁSI ÜGYNÖKSÉG KORLÁTOLT FELELOSSÉGU TÁRSASÁG  ISRAEL LTD  ITALIA S.P.A.  KENYA LIMITED  KOREA LTD.  LATVIJA SIA  LIBERIA LIMITED  LINE UK LIMITED  LOGISTICS DE NICARAGUA S.A.  LOGISTICS TANZANIA LTD  LOGISTICS UK LIMITED  MADAGASCAR SA  MALI SA  MARITIME  MAROC SA  MAURITIUS LTD  MÉXICO, S.A. DE C.V.  MOZOMBIQUE LDA  NAMIBIA  NEW ZEALAND LIMITED  NORGE AS  OIL ANGOLA A/S  OIL B.V.  OIL BRASIL LTDA  OIL COLOMBIA A/S  OIL EGYPT A/S  OIL GB LIMITED  OIL KAZAKHSTAN GMBH  OIL KUWAIT B.V.  OIL MOROCCO GMBH  OIL NORTH AFRICA A/S  OIL NORTH SEA UK LIMITED  OIL NORWAY AS  OIL OMAN B.V.  OIL QATAR A/S  OIL TURKMENISTAN B.V.  OIL UK LIMITED  ÖL UND GAS GMBH  ÖSTERREICH GESELLSCHAFT M.B.H.  PAKISTAN (PVT) LTD  ROMANIA SRL  SIERRA LEONE LTD  SINGAPORE PTE. LTD.  SLOVAKIA SRO  SUPPLY SERVICE CANADA LTD  SUPPLY SERVICE UK LIMITED  SVERIGE AB  SWITZERLAND GMBH  TAIWAN LIMITED  TOGO SA  TRAINING SVENDBORG A/S  UGANDA LTD.  UKRAINE LTD  VIETNAM LTD  WEST AND CENTRAL ASIA LIMITED  ZANZIBAR LIMITED -FILIPINAS INC MÆRSK OLIE, ALGERIET A/S MCC TRANSPORT LIMITED QING DAO MA SHI JI JI ZHUANG XIANG GONG YE YOU XIAN GONG SI SAFMARINE CONTAINER LINES STAR AIR A/S TECONVI S/A. TERMINAIS DE CONTÊINERES DO VALE DO ITAJAÍ. TERMINAL 4 S.A. UAB  LIETUVA UNIVERSAL MARITIME SERVICE CORP. ZAO  SHIPBUILDING YARD BALTIJA AITHER MARITIME LIMITED DAMCO INTERNATIONAL A/S  NEPAL PRIVATE LTD REDERIET A.P. MØLLER A/S  TANGIER SA  CAMEROUN SA SIAM SHORESIDE SERVICES CO LTD  (JAMAICA) LTD  BAHRAIN BSC(C)  KALININGRAD MOBILE CONTATINER TERMINALS LLC APM SAIGON SHIPPING COMPANY BANGKOK MARINE COMPANY LIMITED GATEWAY TERMINALS INDIA PRIVATE LTD  MALAYSIA SDN BHD  NIGERIA LTD AP MOLLER TERMINALS & CO LTD INTTRA INC.  SHIPPING SERVICES & CO LLC  MAURITANIA  APAPA LIMITED GUJARAT PIPAVAV PORT LTD. SUEZ CANAL CONTAINER TERMINAL ANCHOR STORAGE LTD. DFDS SEAWAYS B.V.  GABON SA  LEBANON SARL  SHIPPING COMPANY LIMITED SOGESTER - SOCIEDADE GESTORA DE TERMINAIS SA AGENCIA DE NAVAGACAO  MACAU LDA  VIRGINIA, INC. CONTAINER SHIP MANAGEMENT, LTD CTO CEARA TERMINAL OPERATOR LTDA DAMCO BELGIUM DANSK SUPERMARKED A/S  (CHINA) SHIPPING COMPANY LIMITED  BROKER K/S  CANADA INC  COLOMBIA S A  DEL ECUADOR, C.A.  DRILLING USA INC.  HELLAS LTD  INC.  JUPITER [NAME], S A  K.K.  LOGISTICS MAROC SA  LOGISTICS USA INC  SEALAND /  LINE MARITIME AND TRANSPORT SERVICES LIMITED SVITZER CARRIBEAN LTD  DACHAN  CO LTD AQABA CONTAINER TERMINAL COMPANY LTD AURAI MARITIME LIMITED EGYPTIAN DRILLING COMPANY LR2 MANAGEMENT K/S  (JORDAN) WLL  PRODUCT TANKERS A/S  SENEGAL SA  SUPPLY SERVICE (ANGOLA) SA  TUNESIE SA NORTH SEA PRODUCTION COMPANY LIMITED NORTH SEA TERMINAL BREMERHAVEN GMBH & CO. TERMINAL PORTE OCEANE XIAMEN SONGYU CONTAINER TERMINAL CO LTD CAI MEP INTERNATIONAL  KANOO (UAE) LLC  KANOO BAHRIAN W.L.L  KUWAIT CO WLL SHANGHAI EAST CONTAINER TERMINAL CO LTD SHANGHAI TIE YANG MULTIMODAL TRANSPORTATION CO LTD SMART LOGISTICS COMPANY LTD VOLTRI TERMINAL 2 S.R.L. ABBREVIATO VT2 S.R.L. DOUALA INTERNATIONAL TERMINAL  LANKA (PVT) LTD SOCIETE D EXPLOITATION DU TERMINAL DE VRIDI F. SALLING A/S HØEGH AUTOLINERS AS LAEM CHABANG CONTAINER TERMINAL 1 LTD GETMA GABON SA HANDYTANKERS K/S MEDCENTER CONTAINER TERMINAL S.P.A. MERIDIAN PORT SERVICES WEST AFRICA CONTAINER TERMINAL NIGERIA LTD DFDS AS SALALAH PORT SERVICES COMPANY SAOG PELABUHAN TANJUNG PELEPAS SDN BHD SOUTH ASIA GATEWAY TERMINALS PTE LTD DANSKE BANK A/S DALIAN PORT CONTAINER TERMINAL CO LTD QINGDAO QIANWAN CONTAINER TERMINAL CO LTD TIANJIN PORT ALLIANCE INTERNATIONAL CONTAINER TERMINAL CO., LTD. ANPARTSSELSKABET AF 8. FEBRUAR 2005 MÆRSK GIANT NORGE A/S NADIRO A/S P-N 2001 A/S POLARIS MANAGEMENT A/S HØEGH AUTOLINERS HOLDINGS AS K/S MEMBRANE 1 K/S MEMBRANE 2 POLARIS PRIVATE EQUITY II K/S SAFMARINE (PTY) LTD