Unanswered

undefined

(0) Share

Report

Posted on by lisha

There is a scenario where i have three excel files and I need to merge those excel files in to one master files on the specified columns and the conditions is there are three column name which is same in all the files but the content is different. So how can I merge these files into one?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

Are you saying the 3 columns are in a different order on each workbook?

Was this reply helpful? Yes No
tkuehara 667 on at

Like (0)

Report
Copy link

Link copied!
Hi @lisha

It really depends on what approach you want to use:
Use a macro
Use Excel as a database source
Use PAD to open the files and copy and paste values to another workbook

Here I'll assume you want the latter. In this case, I'm also assuming what you want is illustrated in the picture below:
target result

In this case, you can setup your flow as follows:
Please notice I have two different Excel instances: one for the final file (%MergedExcel%) and the other temporary ones (%ExcelInstance%)

Was this reply helpful? Yes No