I have n number of excel files having same column say “Name”, now I want to pic each file and copy their respective column in different columns of a data table is this possible?
Here i have attached a sample project for your sitiuation.
It has the folder that is having the xl files.
File : Copy data from n Number.zip (29.1 KB)
File 2 :
File 3 :
File 4 :