Forum Discussion

George Bonanza's avatar
George Bonanza
Copper Contributor
Jun 17, 2019

Power Query Loads Table With Additional Blank Column

Every time I initially load Power Query output to a worksheet the table is always loaded with an additional column that is not in my data.

 

For example, if the query I build has a table with 5 columns when I click Close and Load for the first time the output has 6 columns where the added column is blank and labeled "Column 1".

 

I believe this only happens when I load it to an existing worksheet.

 

Any idea why this is happening?  I am loading the output to an existing blank sheet.

 

Thanks in advance.

 

Resources