Replace values if the other column has values, if not leave it

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @JavRR ,
Same QA,
You can try

How to import data from one excel file and put it in the desired column in another excel file?

Hi @Famui_Yanisa , I think you want to write column C in file1 to column Animals (A1) in file2, column B to A-Z, and column A to Column Number(C1) You can -use excel read range file1 -filter data to get column what you need keep -use write range to file2 My in/out [image] My code [image] [image] [image] regards,

move_index_column.xaml (24.5 KB)

Regards,
LNV