Add Missing Headers with Power Query Before Combining Sheets in WPS Office
Question details
The user needs to combine multiple worksheets or tables in Power Query when one table contains data without column names, reusing correct column names from an existing query before appending.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Combining or appending sheets where one table is missing headers while another query already has the matching column names.
- Observed behavior
- The headerless table must be renamed from the existing query so its columns align before being combined with the matching-header table.
Confirm that the query with the correct column names, such as Query1, exists in the same workbook and that the headerless data is defined as a named table or range before launching Power Query.
Rename the headerless query columns from Query1 before appending
Use this method when one table already has correct headers and another worksheet or table has data without column names; it reuses Query1 column names so the append step aligns all columns.
Power Query can reference an existing query with Table.ColumnNames and then rename the source columns before the final combine. This keeps column order and names consistent without manually typing every header.
In WPS Spreadsheets, click inside the headerless table or range, go to the Data tab, and select From Table/Range to load it into Power Query Editor.
In the Power Query Editor, create a new blank query or open the Advanced Editor and enter a query such as: Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], names = Table.ColumnNames(Query1), rename = Table.RenameColumns(Source, List.Zip({Table.ColumnNames(Source), names})).
Close the editor or keep the query loaded, then use Append Queries from the Home tab in Power Query to combine the renamed query with the table that already has matching headers.
Confirm the appended output shows the original header names in the correct columns and that all rows from the headerless table are included.

Fix Missing Headers in WPS Office Power Query Before Combining Sheets
WPS Office Spreadsheets lets you open Power Query, reference an existing query, rename a headerless table from Query1, and then append the sheets into one clean dataset. You can complete the entire header-alignment task directly in WPS Office without switching to another spreadsheet editor.
- 1. Open WPS Office Spreadsheets: Launch WPS Office Spreadsheets and open the workbook containing the query with correct headers and the headerless table.
- 2. Load the headerless table into Power Query: Click inside the headerless table, go to the Data tab, and select From Table/Range to create a query in Power Query Editor.
- 3. Reference the existing query: Use the Advanced Editor or a blank query to enter the rename expression that calls Table.ColumnNames(Query1) and Table.RenameColumns for the headerless source.
- 4. Append and load the final table: Use Append Queries to combine the renamed query with the table that already has matching headers, then choose Close & Load to return the final table to WPS Spreadsheets.

Frequently Asked Questions
Can I combine a headerless table with a table that already has headers in WPS Power Query?
Yes. Load the headerless table into Power Query, rename its columns from the existing query using Table.ColumnNames and Table.RenameColumns, then append the renamed query to the table with matching headers.
What does Table.RenameColumns do in this Power Query solution?
Table.RenameColumns changes the column names of the headerless source to the names taken from Query1. This ensures the columns line up correctly before the append operation.
Do the column names from Query1 need to match the headerless table column count?
The headerless table should have the same number of columns as the existing query. If the counts differ, Power Query may produce extra columns, null values, or an error during the rename or append step.
Can I use this method for more than two sheets or tables?
Yes. You can rename each headerless query from the same trusted query and then append all renamed queries together, as long as the column names, order, and data types are consistent.




