Hello ,

i have 2 sheet in sheet1 I have 4 column like the below image that you see A To D and column A have duplicate data but other column Have Different data .

I need to merge all column that their column A is same and give me the result like second image on sheet2

Please help me on this subject



I need this result in sheet2 , that mean data on column C1 added to first of data on column B1 and add () and dara on column D1 added between ().