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

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
7 years ago

In the top left corner of the table is a context menu. Click it, and select “remove top rows, 1”