Sync sheets w/ excel problem

[fishkeeper]

So I have my excel sheet synced with my google sheets successfully, there is nothing wrong there, it updates fine and has no issues. The small annoying problem I have is that my headers are incorrect.

For example, on my Google sheets, it looks like this:

which is how I want it to look, however now on my excel sheet, it looks like this:

And even if I rename A1 from Column1 to Stock #, and Column2 to Item ID etc, I then just end up with a duplicate line because A1,B1,C1,D1,E1,F1,G1 with be identical to A2,B2,C2,D2,E2,F2,G2 etc. and I can't seem to find a way to correct it because it's all being synced over from Google sheets. So even if I delete Row 2, it won't matter because when it updates, it will be replaced again and again.

Any ideas? I would greatly appreciate it! <3

 

[severynm]

How are you syncing from Google Sheets? Via Power Query? If so you'll need to add a step to your query to promote headers.

 

[fishkeeper]

How are you syncing from Google Sheets? Via Power Query? If so you'll need to add a step to your query to promote headers.

Thank you so much severynm!!! That fixed my problem. I greatly appreciate your help