Merge Cells in Column C if combination of Column A and B values are same

[Krithi1]

Hi,

I have the data as below

I need to merge “Column C” is “Column A and Column B” are same as in below screenshot. How can achieve that? I can’t use any other packages apart from UiPath and Microsoft packages. I can use vb or c # code by invoke code activity

[Jose_Cunha (José Cunha)]

Hello.

Try this

vba to merge Rows based on Values in Column A

Hug

[Krithi1]

Hi @Jose_Cunha

I cant use macros code because of the security reasons

[Jose_Cunha (José Cunha)]

Can you use external packages? If yes, try this one:

BalaReva.Excel.Activities

Hi Friends, I have included some new activities in the “BalalReva.Excel.Actities”. Activities 1.Copy Data activity - It copies the data from Excel Sheet to the clipboard 2.Delete Data activity - It deletes the data in the Excel Sheet 3.Clipboard To Datatable activity - It converts the clipboard to Datatable Namespace [image] 1.Properties Copy Data activity [image] Sample File : CopyData.zip (8.1 KB) 2.Properties of Delete Data activity [image] Sample : DeleteData.zip (6.9 KB) 3.…

[Krithi1]

Hi @Jose_Cunha

No, I can’t

[Krithi1]

Hi All,

Anybody has any suggestions here?

[supermanPunch (Arpan)]

Hi @Krithi1 ,

Could you check the below workflow :
Excel_MergeCells_BasedOnGroup.zip (11.0 KB)

[Krithi1]

@supermanPunch - thank you. It worked.