How to merge excel sheets

[E.T.S]

Hello,

I have a sheet in Excel like this:

And another like this:

What I would like to do is merge these two so the output is like this:

I have tried various methods but the output is not exactly how I want

Please advise cheers

[Kanak_Lata_Singh]

Hi @E.T.S

Please look into below thread

Merge excel files in uipath

I have three excel file and want to merge it to one. How to do it.

[Krishna_Raj]

@E.T.S

How to merge multiple sheets

@sneha_arbole Try below steps. First use Excel Application Scope activity and create one workbook variable for this. And then use varWB.GetSheets to get all sheets from Excel file. Excel Application Scope ForEach item in varWB.GetSheets - Use Read Range activity and pass item under sheet name and store output in DataTable - Use Merge DataTable activity to merge all sheets data and pass output of Read Range activity

check the reference above provided

[ashokkarale]

@E.T.S.

Are you trying to merge the two files with different columns sequence?

Thanks,
Ashok