parscon
02-18-2014, 03:02 PM
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
http://i61.tinypic.com/28h0whg.png
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 ().
http://i62.tinypic.com/2ljjna1.png
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
http://i61.tinypic.com/28h0whg.png
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 ().
http://i62.tinypic.com/2ljjna1.png