Power Query Problems

How to Append Excel Data Without Duplicating Headers

Anum MushtaqAnum Mushtaq Nov 2, 2026 870 views

Question details

The user needs to combine data from multiple Excel workbooks without importing the source table headers as regular data rows in the final dataset.

How to Append Excel Data from Another Workbook Without Duplicating Headers
Product
Excel
Device & OS
not provided
Scenario
Appending data from one large workbook to another containing matching headers using the Get Data feature.
Observed behavior
Using standard import methods imports the source file's header as an unwanted data row within the combined table.
Before you start

Ensure both source workbooks are saved and closed, and verify that the column headers in all tables match exactly in spelling and case to prevent misaligned columns.

Solution 1Recommended

Use Power Query to Append Tables

Power Query is the most reliable method for this task, as it automatically matches headers and combines rows while keeping only a single header row for the entire dataset.

By appending queries rather than manually pasting data, Power Query matches columns strictly by header name rather than their position. This avoids misaligned data and strips out redundant header rows.

1
Convert data to tables

Open your source workbooks and convert the data ranges into Excel Tables by pressing Ctrl + T.

2
Import data into Power Query

In your main workbook, go to the Data tab, click Get Data > From File > From Workbook, and import your tables to create a connection.

3
Append the queries

Open the Power Query Editor. Go to the Home tab and select Append Queries (or Append Queries as New). Select the tables you want to combine.

4
Load the combined data

Verify that the appended table contains only one header row. Click Close & Load to export the merged dataset back into your Excel worksheet.

Use Power Query to Append Tables
Handling Unmatched Columns: If one table has columns that the other does not, Power Query places the unmatched values in new columns and fills the missing spaces with 'null'.
Efficient Data Management

Combine Workbooks Seamlessly in WPS Spreadsheet

WPS Spreadsheet provides powerful and intuitive data management tools. With built-in consolidation and intelligent table merging features, you can combine large datasets effortlessly without generating duplicate header rows.

  1. 1. Open WPS Spreadsheet: Launch WPS Office and open your primary workbook.
  2. 2. Access Data Consolidation: Navigate to the Data tab and click on the Consolidate tool.
  3. 3. Select Source Ranges: Click Add to select the data ranges from your target workbooks that you wish to combine.
  4. 4. Use Top Row Labels: Check the box for 'Top row' under 'Use labels in' to ensure headers are matched and merged perfectly without duplication.
Easily consolidate data from multiple worksheets without writing complex formulas.Fully compatible with Microsoft Excel file formats (.xlsx, .xls, .csv).Lightweight application that handles large datasets quickly and smoothly.Clean, intuitive interface familiar to all Excel users.
microsoft office alternative - wps office

Frequently Asked Questions

Why are my headers still duplicating after appending in Power Query?

This happens when header names are not an exact match. Power Query is case-sensitive, so 'Sales' and 'sales' are treated as two different columns. Ensure there are no trailing spaces or spelling differences in your source headers before appending.

Can I append more than two Excel tables at the same time?

Yes. When you click Append Queries on the Home tab of the Power Query Editor, you can select the 'Three or more tables' option. This allows you to add multiple tables from 'Available tables' to 'Tables to append' in one operation.

What happens if I append tables with columns in a different order?

Power Query appends data by matching the column header names, not their physical position in the worksheet. As long as the header names match exactly, the data will align perfectly under the correct column regardless of its original order.