How to Promote the Third Row as Headers in Power Query in WPS Office
Question details
The user needs to remove unwanted top rows in Power Query Editor and promote the correct third row as the table header.

- Product
- WPS Office Spreadsheets - Power Query Editor
- Device & OS
- not provided
- Scenario
- Imported data contains two unnecessary rows above the intended header row, so the user wants the third row to become the column headers.
- Observed behavior
- The current table header is incorrect because two source rows appear above the intended header row.
Open the workbook in WPS Office and launch Power Query Editor from the Data tab. Confirm in the preview grid that exactly two rows appear above the intended header row before you remove them.
Remove the Top Two Rows and Promote the Third Row as Headers in WPS Power Query
Use this method when the intended header row is not the first row and you need to remove the rows above it before promotion.
Power Query only promotes the current first row as headers. If the real header is in the third row, you must first remove the two rows above it, then use Use First Row as Headers.
In WPS Office Spreadsheets, open the source table and go to Data > Power Query Editor to open the query editing window.
In Power Query Editor, click Home > Remove Rows > Remove Top Rows, enter 2, and confirm to delete the two unwanted rows above the intended header.
Click Home > Use First Row as Headers. The third source row now becomes the header row for the table.
Click Home > Close & Load to return the cleaned table with the correct headers to the worksheet.
Promote the Third Row as Headers with WPS Office Power Query
WPS Office lets you clean and reshape imported data directly in Power Query Editor. Remove extra top rows and promote the correct row as the header, then load the corrected table back into your spreadsheet.
- 1. Open the workbook: Launch WPS Office Spreadsheets and open the workbook that contains the source table.
- 2. Launch Power Query Editor: Select the data area and go to Data > Power Query Editor to start cleaning the table.
- 3. Remove top rows: Click Home > Remove Rows > Remove Top Rows, enter 2, and confirm to remove the unwanted rows.
- 4. Use first row as headers: Click Home > Use First Row as Headers to promote the third source row into the header row.
- 5. Close and load: Click Close & Load to write the cleaned table back into the worksheet.

Frequently Asked Questions
Can I promote the third row as headers without removing the first two rows?
No. Use First Row as Headers only promotes the current top row of the query. You must use Remove Rows > Remove Top Rows to delete the two rows above the intended header first.
What happens to the two rows I remove in Power Query?
They are removed from the query output. The rows will not appear in the loaded table after you click Close & Load.
Does removing top rows in Power Query change my original data source?
No. Power Query transformations are applied in the query. The original source data remains unchanged unless you overwrite it after loading.
Can I undo the Remove Top Rows step if I entered the wrong number?
Yes. In Power Query Editor, use the Applied Steps pane on the right side to delete or edit the Removed Top Rows step and try again.
Is Power Query Editor available in WPS Office?
Yes. In WPS Office Spreadsheets, open a source table and go to Data > Power Query Editor to access the Power Query cleaning and transformation tools.




