Combine 2 cells if one cell contains same text
Hi,
I want to combine the Column “Generic Name” into one cell seperated by a comma if Column “Drug Code” has the same code
As you see from the example below
Drug Code 0401000010 has 2 Generic Name
0401000010 = Amoxicillin
0401000010 = Clavulanic Acid
i want it to be combined into one cell (Coumn “Combined”)
0401000010 = Amoxicillin, Clavulanic Acid
What formula can i use to achieve this result
Thank you
DRUG CODEGeneric NameCombined0401000010AmoxicillinAmoxicillin,Clavulanic acid0401000010Clavulanic acidAmoxicillin,Clavulanic acid0401000011AmoxicillinAmoxicillin,Clavulanic acid0401000011Clavulanic acidAmoxicillin,Clavulanic acid0401000056CetirizineCetirizine, Cetirizine Hydrochloride0401000056Cetirizine HydrochlorideCetirizine, Cetirizine Hydrochloride
Hi, I want to combine the Column “Generic Name” into one cell seperated by a comma if Column “Drug Code” has the same code As you see from the example below Drug Code 0401000010 has 2 Generic Name0401000010 = Amoxicillin0401000010 = Clavulanic Acid i want it to be combined into one cell (Coumn “Combined”) 0401000010 = Amoxicillin, Clavulanic Acid What formula can i use to achieve this result Thank youDRUG CODEGeneric NameCombined0401000010AmoxicillinAmoxicillin,Clavulanic acid0401000010Clavulanic acidAmoxicillin,Clavulanic acid0401000011AmoxicillinAmoxicillin,Clavulanic acid0401000011Clavulanic acidAmoxicillin,Clavulanic acid0401000056CetirizineCetirizine, Cetirizine Hydrochloride0401000056Cetirizine HydrochlorideCetirizine, Cetirizine Hydrochloride Read More