Spreadsheet: 121751d1316385731-excel-2007-merging-information-from-multiple-rows-for-duplicate-entries-example
Sheet: Sheet2

ATP Therapeutic Area | Indication 1 | Indication 2 | Indication 3 | Indication 4 | Indication 5 | Indication 6 | Indication 7 | Concat | Duplicates
RHEUMATOLOGY | OSTEOARTHRITIS |  |  |  |  |  |  | EadeJoelCAMPBELLSVILLEUnited States
ENDOCRINOLOGY | DIABETES TYPE 2 |  |  |  |  |  |  | EagertonDonaldMYRTLE BEACHUnited States
ENDOCRINOLOGY | DIABETES TYPE 2 |  |  |  |  |  |  | EagertonDonaldMYRTLE BEACHUnited States | Duplicate
ENDOCRINOLOGY | DIABETES TYPE 2 |  |  |  |  |  |  | EagertonDonaldMYRTLE BEACHUnited States | Duplicate
RHEUMATOLOGY | OSTEOARTHRITIS |  |  |  |  |  |  | EastCaraDALLASUnited States
RHEUMATOLOGY | OSTEOARTHRITIS |  |  |  |  |  |  | EatonGregoryMANSFIELDUnited States
CARDIOVASCULAR | CORONARY ARTERY LESIONS |  |  |  |  |  |  | EberBerndWELSAustria
RHEUMATOLOGY | OSTEOARTHRITIS |  |  |  |  |  |  | EberlyJohnTAYLORSUnited States
ENDOCRINOLOGY | DIABETES TYPE 2 |  |  |  |  |  |  | EberlyJohnTAYLORSUnited States
NEUROLOGY | PARKINSON'S DISEASE |  |  |  |  |  |  | EbersbachGeorgBEELITZ-HEILSTAETTENGermany
HEMOG/ONC/TRANSPLANTATION | HEAD AND NECK CANCER |  |  |  |  |  |  | EbrahimiBehnamLE VERNAUnited States
HEMOG/ONC/TRANSPLANTATION | MELANOMA |  |  |  |  |  |  | EbrahimiBehnamPOMONAUnited States
RHEUMATOLOGY | OSTEOARTHRITIS |  |  |  |  |  |  | EbrahimiRaminLOS ANGELESUnited States
RHEUMATOLOGY | OSTEOARTHRITIS |  |  |  |  |  |  | EckerAndrewKING OF PRUSSIAUnited States
ENDOCRINOLOGY | DIABETES TYPE 2 |  |  |  |  |  |  | EckertKathrynRENOUnited States
CARDIOVASCULAR | CAROTID ARTERY DISEASE |  |  |  |  |  |  | EckhauserMarcMESAUnited States
RHEUMATOLOGY | OSTEOARTHRITIS |  |  |  |  |  |  | EcklundSteveBOISEUnited States
RHEUMATOLOGY | OSTEOPOROSIS |  |  |  |  |  |  | EconsMichaelINDIANAPOLISUnited States
RHEUMATOLOGY | OSTEOARTHRITIS |  |  |  |  |  |  | EddyRichardMEDFORDUnited States
RHEUMATOLOGY | RHEUMATOID ARTHRITIS |  |  |  |  |  |  | EdelmannEdmundBAD AIBLINGGermany
HEMOG/ONC/TRANSPLANTATION | MELANOMA |  |  |  |  |  |  | EdenfieldJeffGREENVILLEUnited States
HEMOG/ONC/TRANSPLANTATION | NON SMALL CELL LUNG CANCER | KIDNEY CANCER |  |  |  |  |  | EdenfieldWilliamGREENVILLEUnited States
HEMOG/ONC/TRANSPLANTATION | NON SMALL CELL LUNG CANCER |  |  |  |  |  |  | EdenfieldWilliamGREENVILLEUnited States | Duplicate
HEMOG/ONC/TRANSPLANTATION | KIDNEY CANCER |  |  |  |  |  |  | EdenfieldWilliamGREENVILLEUnited States | duplicate
HEMOG/ONC/TRANSPLANTATION | NON SMALL CELL LUNG CANCER |  |  |  |  |  |  | EdenfieldWilliamGREENVILLEUnited States | duplicate
CARDIOVASCULAR | CORONARY ARTERY DISEASE |  |  |  |  |  |  | EdmondJohnWESTON SUPER MAREUnited Kingdom
RHEUMATOLOGY | OSTEOARTHRITIS |  |  |  |  |  |  | EdrisMarwanMISSION VIEJOUnited States
RHEUMATOLOGY | OSTEOARTHRITIS |  |  |  |  |  |  | EdwardsJamesNEWPORT NEWSUnited States
CARDIOVASCULAR | CAROTID ARTERY DISEASE |  |  |  |  |  |  | EdwardsMatthewWINSTON-SALEM,United States
RHEUMATOLOGY | OSTEOARTHRITIS |  |  |  |  |  |  | EdwardsWilliamCHARLESTONUnited States
CARDIOVASCULAR | CAROTID ARTERY DISEASE |  |  |  |  |  |  | EdwardsWilliamNASHVILLEUnited States
WOMENS HEALTH/SEXUAL HEALTH | ERECTILE DYSFUNCTION |  |  |  |  |  |  | EfrosMitchellGARDEN CITYUnited States
WOMENS HEALTH/SEXUAL HEALTH | ERECTILE DYSFUNCTION |  |  |  |  |  |  | EfrosMitchellGARDEN CITYUnited States
WOMENS HEALTH/SEXUAL HEALTH | ERECTILE DYSFUNCTION |  |  |  |  |  |  | EfrosMitchellGARDEN CITYUnited States
WOMENS HEALTH/SEXUAL HEALTH | ERECTILE DYSFUNCTION |  |  |  |  |  |  | EfrosMitchellGARDEN CITYUnited States
CARDIOVASCULAR | HIGH BLOOD PRESSURE |  |  |  |  |  |  | EfrosMitchellGARDEN CITYUnited States
WOMENS HEALTH/SEXUAL HEALTH |  |  |  |  |  |  |  | EfrosMitchellGARDEN CITYUnited States
WOMENS HEALTH/SEXUAL HEALTH |  |  |  |  |  |  |  | EgerdieRussellKITCHENERCanada
WOMENS HEALTH/SEXUAL HEALTH |  |  |  |  |  |  |  | EgerdieRussellKITCHENERCanada
NEUROLOGY | PARKINSON'S DISEASE |  |  |  |  |  |  | EhlerEdvardPARDUBICECzech Republic
NEUROLOGY | PARKINSON'S DISEASE |  |  |  |  |  |  | EhretReinhardBERLINGermany
RHEUMATOLOGY | OSTEOARTHRITIS |  |  |  |  |  |  | EiderWendyYAKIMAUnited States
CARDIOVASCULAR | CAROTID ARTERY DISEASE |  |  |  |  |  |  | EidtJohnLITTLE ROCKUnited States
HEMOG/ONC/TRANSPLANTATION | BONE METASTASES |  |  |  |  |  |  | EiermannWolfgangMUENCHENGermany
HEMOG/ONC/TRANSPLANTATION | BONE METASTASES |  |  |  |  |  |  | EinseleHermannWUERZBURGGermany
HEMOG/ONC/TRANSPLANTATION | ORAL [NAME] |  |  |  |  |  |  | EinseleHermannWUERZBURGGermany
HEMOG/ONC/TRANSPLANTATION | LYMPHOMA |  |  |  |  |  |  | EisenbeisCharlesRALEIGHUnited States
HEMOG/ONC/TRANSPLANTATION | NON SMALL CELL LUNG CANCER |  |  |  |  |  |  | EisenbergPeterGREENBRAEUnited States
HEMOG/ONC/TRANSPLANTATION | NON SMALL CELL LUNG CANCER |  |  |  |  |  |  | EisenbergPeterGREENBRAEUnited States
HEMOG/ONC/TRANSPLANTATION | LYMPHOMA |  |  |  |  |  |  | EisenbergPeterGREENBRAEUnited States
HEMOG/ONC/TRANSPLANTATION | COLON CANCER |  |  |  |  |  |  | EisenbergPeterGREENBRAEUnited States
INFECTIOUS DISEASE | INFLUENZA |  |  |  |  |  |  | EitnerFrankAACHENGermany
RHEUMATOLOGY | OSTEOARTHRITIS |  |  |  |  |  |  | El AsmarImadCOMMERCEUnited States
ENDOCRINOLOGY | DIABETES TYPE 2 |  |  |  |  |  |  | El GayarHishamCAIROEgypt
GASTROINTESTINAL | ULCERATIVE COLITIS |  |  |  |  |  |  | El NawarAbdoMOUSCRONBelgium
RHEUMATOLOGY | OSTEOARTHRITIS |  |  |  |  |  |  | El SayadNabilLOMITAUnited States
PSYCHIATRY | ADHD |  |  |  |  |  |  | El WasifyMahmoudMANSOURAEgypt
NEUROLOGY | MULTIPLE SCLEROSIS |  |  |  |  |  |  | ElaginaIrinaMOSCOWRussian Federation
INFECTIOUS DISEASE | HEPATITIS C |  |  |  |  |  |  | ElbeshbeshyHanyOKLAHOMA CITYUnited States
ENDOCRINOLOGY | DIABETES TYPE 2 |  |  |  |  |  |  | EldeirySamerALBANYUnited States
RHEUMATOLOGY | RHEUMATOID ARTHRITIS |  |  |  |  |  |  | El-GabalawyHaniWINNIPEGCanada
GASTROINTESTINAL | ULCERATIVE COLITIS |  |  |  |  |  |  | EliakimAbrahamHAIFAIsrael
HEMOG/ONC/TRANSPLANTATION | SOFT TISSUE SARCOMA |  |  |  |  |  |  | EliasAnthonyAURORAUnited States
ENDOCRINOLOGY | DIABETES TYPE 2 |  |  |  |  |  |  | EliaschewitzFreddySAO PAULOBrazil
RHEUMATOLOGY | OSTEOARTHRITIS |  |  |  |  |  |  | EliaschewitzFreddySAO PAULOBrazil
NEUROLOGY | MULTIPLE SCLEROSIS |  |  |  |  |  |  | EliasWolfgangHAMBURGGermany
RHEUMATOLOGY | OSTEOARTHRITIS |  |  |  |  |  |  | ElijahRochellePUEBLOUnited States
PSYCHIATRY | DEPRESSION |  |  |  |  |  |  | El-KhaliliNizarLAFAYETTEUnited States
PSYCHIATRY | DRUG DEPENDENCY |  |  |  |  |  |  | El-KhaliliNizarLAFAYETTEUnited States
PSYCHIATRY | MAJOR DEPRESSIVE DISORDER |  |  |  |  |  |  | El-KhaliliNizarLAFAYETTEUnited States
PSYCHIATRY | ADHD |  |  |  |  |  |  | El-KhaliliNizarLAFAYETTEUnited States
PSYCHIATRY | DEPRESSION |  |  |  |  |  |  | El-KhaliliNizarLAFAYETTEUnited States
NEUROLOGY | [NAME] |  |  |  |  |  |  | El-KhaliliNizarLAFAYETTEUnited States
PSYCHIATRY | MAJOR DEPRESSIVE DISORDER |  |  |  |  |  |  | El-KhaliliNizarLAFAYETTEUnited States
PSYCHIATRY | SCHIZOPHRENIA |  |  |  |  |  |  | ElkinSergeyST. PETERSBURGRussian Federation
PSYCHIATRY | SCHIZOPHRENIA |  |  |  |  |  |  | ElkinSergeyST. PETERSBURGRussian Federation