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.
Do I understand correctly what in Power Query Editor you see only 5 columns?
That is correct. The query I build has only 5 columns.
Could you attach small sample file?