Power query - misaligned column data after export from multiple worksheets

[Pineapplecake]

Hi All - I have a file with multiple worksheets that I want to consolidate via power query into one big list. Each worksheet has consistent column names and order

However when loading the data , only one of the worksheets seems to load an extra column which causes all the other row data to misalign like the example below

Worksheet column names in the file (all the same)
Name | country | team | role

Power query exported columns:
Name | blank | country | team | role
Sheet 1 | <blank> | US | team 1 | BA
Sheet 2 | Canada | Team 2 | team 2 | <blank>

I can’t find what the issue is as all the worksheets are in order and same names and it's only for this one worksheet out of the 8 causing this problem. Would anyone be able to help? Thank you’

 

[GraH]

Would you have in that specific file/sheet a merged cell? Power Query will "see" 2 columns, and create a columns with all blanks.

 

[Pineapplecake]

Would you have in that specific file/sheet a merged cell? Power Query will "see" 2 columns, and create a columns with all blanks.

The file is work related so I'm not able to share.

However I found if I delete a column in my worktab and add it back in, the power query doesn't pick up the extra blank column so not sure what it is

 

[GraH]

Hi, I did not ask to share, but to look for any merged cells.
You can share the PQ code for your second question though.
Would you have columns names that look alike but aren't? Trailing of leading spaces, capitals or lower case, typos,... Stuff like that. Do you a hardcoded definition of the columns to show inside the PQ?
Even if you have source tables where the columns are in a different order, PQ would still combine them correctly. Is the column header that matters, not the order.