Merge multiple csv with specified columns

excel

#1

1.How can i merge multiple columns with different primaryKey.Loop is not good for there thousands of rows in a sheet.testCsvMerge.zip (5.4 KB)
2.how to Remove duplicate elements so that i can set primaryKey.
Thank you very much.