Excel Value

Hi All,

I have 2 excel file(file1 and file2)
I need to reconsulation from file2 to file1
Can anyone pls guide me how to do?
challenge is file1 and file2 have same column names multiple times.

and the final file ie file1 should look like this

Please guide me on this how to do further.Thanks

Try using Read range and specify range A:C for file1 and H:I for second file. Now merge columns of both data tables. If column names are same then u need to use read range without headers.

Not working

u r trying to merge tables by rows. try merging columns by using add data column activity

This It didn’t worked

You can use VlookUp for this in File 1

Hi @Sharanabasava_Kallur,

Hope this will help you,


1 Like