Power Query Problems

Add Missing Headers with Power Query Before Combining Sheets in WPS Office

Khadija KhanKhadija Khan Nov 13, 2026 869 views

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.

Add Missing Headers with Power Query Before Combining Sheets
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Power Query for the headerless table

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.

2
Create a rename query using Query1

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})).

3
Apply and append the renamed query

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.

4
Verify the combined result

Confirm the appended output shows the original header names in the correct columns and that all rows from the headerless table are included.

Rename the headerless query columns from Query1 before appending
Headers reused successfully: After the rename step, the headerless table uses Query1 column names, so the append operation aligns data instead of creating extra null or mismatched columns.
Use WPS Spreadsheets Power Query

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. 1. Open WPS Office Spreadsheets: Launch WPS Office Spreadsheets and open the workbook containing the query with correct headers and the headerless table.
  2. 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. 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. 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.
Reuses existing Power Query column names to fix headerless tables before appendingMaintains full compatibility with Microsoft Excel workbook and Power Query workflowsFree and lightweight WPS Office Spreadsheets environment for data transformationFamiliar ribbon and Power Query Editor layout for easy migrationCombine multiple tables without manual retyping or misaligned columns
microsoft office alternative - wps office

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.