Data not loading correctly from folder with excel files

[SteveMtz]

I'm uploading data from a folder with multiple excel files. 

The files are all the same, cells A10:B10 are merged and have "Supplier" written and the name of the supplier is on cell D10

I import the files and then filter by the first column looking for "Supplier" and there are 5 files out of 50 that don't show after the filter.

I verified the original files and the word "Supplier" is in the same cells as the rest of the files but when I look for it in Power Query, the 5 files show null for the same cells.  (the name of the supplier does appear in power query for all files)

Please Help

[androo]

Are you saying that each files contents is the word "Supplier" which is in one of the merged cells A10:B10 (the entry will be in one of them even if the cells are merged)? That column C empty and that cell D10 has the name of the supplier in it, and that's it? Is there nothing else in the files? I think you need to provide a but more detail to get some help.

[SteveMtz]

The file has more information, and I'm making several extractions from it.

Each file is a purchase order and I'm making a PBI of all of them togheter.

There is a list of items in cells a16:g32 (column A = item number, B =description, C = quantity, etc) 

There is a project number in other set of cells, etc. 

The issue is the files that don't show the supplier and I can't find a reason. I don't know why the info doesn't show in Power Query but can be seen in the original excel file.

I copied the cells A10:b10 from a working file and there was no change.