Concatenate with ";" if values of 3 columns are same

[aravindhan_3]

Hi,

Need some vba or excel formula help to concatenate based on conditions.
please find below the as is data and result data , attached the file as well reference. first table is as data and 2nd table is result data.

I want to concatenate values of "Sub product code" ( colc c) if column A, B & Column D are same , example below



Thanks for the help
Regards
Arvind