Hi,
Thanks for the help!
I have here 2 files that I am merging with a folder
The problem is that after the merge - in the After file - in the Part Number column
Data disappears - in rows obtained from the PCB-120-007 file
He just does not load the data
Why??
The data in the second workbook doesn't have the same headers in row1, which means that your query to load the data doesn't produce the same headers as it does for the first file. That's why all the columns end up as null.
Thanks for the quick reply!!
I accidentally uploaded an invalid file
France here the 2 original original files
Thanks for the answer in advance !!
Leah
That one works fine for me (other than the missing Value column).