Power query from excel table imports first row as headers

[chocbudda]

I cannot stop powerquery importing as above. I can promote the headers to first row, but it then has "column9" etc anywhere that I had no data in that first row!

Please point me in the right direction to fix this?

 

[alansidman]

When you select your data/range to bring into the PQE, uncheck the box that says my table has headers. If you do this, then for column 9, just do a rename.