Power Query Problems

How to Promote the Third Row as Headers in Power Query in WPS Office

Rana GarciaRana Garcia Nov 13, 2026 869 views

Question details

The user needs to remove unwanted top rows in Power Query Editor and promote the correct third row as the table header.

How to Promote the Third Row as Headers in Power Query
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Power Query Editor

In WPS Office Spreadsheets, open the source table and go to Data > Power Query Editor to open the query editing window.

2
Remove the top two rows

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.

3
Promote the third row as headers

Click Home > Use First Row as Headers. The third source row now becomes the header row for the table.

4
Load the result

Click Home > Close & Load to return the cleaned table with the correct headers to the worksheet.

Header row promoted: The third source row is now used as the column header row, and the two unwanted top rows are removed.
WPS Spreadsheets Power Query

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. 1. Open the workbook: Launch WPS Office Spreadsheets and open the workbook that contains the source table.
  2. 2. Launch Power Query Editor: Select the data area and go to Data > Power Query Editor to start cleaning the table.
  3. 3. Remove top rows: Click Home > Remove Rows > Remove Top Rows, enter 2, and confirm to remove the unwanted rows.
  4. 4. Use first row as headers: Click Home > Use First Row as Headers to promote the third source row into the header row.
  5. 5. Close and load: Click Close & Load to write the cleaned table back into the worksheet.
Remove multiple top rows and promote the correct header without manual copyingAdjust header rows quickly within the familiar Power Query Editor workflowOpens and saves Excel .xlsx workbooks without losing Power Query formattingFree and lightweight Office suite with a familiar ribbon interface
microsoft office alternative - wps office

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.