Forum Discussion
George Bonanza
Jun 17, 2019Copper Contributor
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.
- George BonanzaCopper Contributor
Could you attach small sample file?