Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Query Editor - delete first row

Hi,   I have a source excel file with headers in the second row. So I wish to delete the first row and promote the next row to headers. Please can you tell me how to delete the first row? (I can't ...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous ,

    Based on my test, you could use the remove the Top N function to delete the first row in query editor:

    Regards,

    Daniel He

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous ,

Based on my test, you could use the remove the Top N function to delete the first row in query editor:

Regards,

Daniel He