Merge excels from 3 folder

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Hi, I have excel files in 3 folders. Sometimes I may have excel files in only 2 out of the 3 folders. I want to merge all of excel files and output it in a 4th folder. How to do so please?

All excel files have 2 columns. One of the excel do not have a heading. So basically I just want to append all excel files. Column0 matches with column0 of other excel files:

one example of an excel file:

Another example:

Kindly help!
Thanks!

Extracted_CSV.zip (14.1 KB)
Extracted_Email_Body.zip (4.7 KB)
Extracted_PDF.zip (6.0 KB)

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Yudhisteer_Chintaram1 ,
We can call each file in the folder
Set it to read range
then write to file output in folder4
we have variable index,
next row of next file is the 1st blank row in output file
regards,

[Parvathy (PS Parvathy)]

Hi @Yudhisteer_Chintaram1

Check out the below workflow file. Hope it meets your requirement.

BlankProcess9.zip (179.3 KB)

Regards,