Getting data from SharePoint folder. some data doesn't pull through and some columns are getting data from wrong columns

[uk747]

Getting data from a SharePoint folder
All files are set up the same, same sheet name and same column headings.

Weird thing some of the details in some of the the columns from files in SharePoint folder goes to a different column in the file with power query. Has anyone experienced this before or maybe suggestions as to why it goes to a different column