In column D I have a case statement that generates numbers if the data in column E is related. I would like to use code to reference the numbers in column D and if the same, concatenate strings from column E into column H. For example:
Col D Col E
23 abc John
24 cca Sam
24 cca Sally
25 dba...