Hi Guys,


I need a script that loops through a folder.


I have two kind of files in the folder:


the filename can be anything the only thing that makes them as a pair is the filename.



UCHP_Translation2_jeeves_sv.xlsx
Contains data in column A

UCHP_Translation2_jeeves_sv_NoTrans.xlx
Contains data: in column B

(more filename of filenames the filename can be almost be any:

Pair one:
UCHP_Translation2_creditDocument_de_.xlsx
Contains data in column A
UCHP_Translation2_creditDocument_de_NoTrans.xlsx
Contains data in column B



Pair:2
UCHP_Translation2_advancedSearch_es.xlsx
Contains data in column A
UCHP_Translation2_advancedSearch_es_NoTrans.xlsx
Contains data in column B



File A have Only data in Column A



File B have only data in Column B




I need to merge the columns. to one and then save to the file example:
UCHP_Translation2_jeeves_sv.xlsx

the thing is also, there is never overlapping text in each cell in the columns, if you put them to one column.
except line 1

Could someone help me with a script?

Thank you in advance.