Skip to content
Safitab

Merge multi-row headers into one row

Grouped headers look tidy in a report — “Q1 2026” spanning Units and Revenue — but any tool that expects one header row sees blank names and duplicates: Units, Revenue, Units, Revenue.

All header levels are combined into one name per column, so every column says what it is: “Q1 2026 / Units”, “Q2 2026 / Revenue”. Merged cells, labels typed only above the first column of a group, and a year above month names are all handled.

Drop files here

or browse your files

XLSX, XLS, CSV, TXT, PDF · up to 25 MB · 1 file without an account

Or try a sample:

Example: before and after

Two header rows became one, and each column name includes its quarter.

Beforequarterly-units.csv
1 Q1 2026 Q2 2026
2ProductUnitsRevenueUnitsRevenue
3Coffee mug1201,680.001351,890.00
4Tote bag801,440.00961,728.00
5Desk lamp251,050.00311,302.00
After3 rows
ProductQ1 2026 / UnitsQ1 2026 / RevenueQ2 2026 / UnitsQ2 2026 / Revenue
Coffee mug1201,680.001351,890.00
Tote bag801,440.00961,728.00
Desk lamp251,050.00311,302.00

How to do it

  1. 1Drop the file with the grouped header.
  2. 2Check the combined names; rename any column with a click on its header.
  3. 3Download with a single header row.

Questions

How many header rows can be combined?
Up to seven, including merged cells across columns and rows, unit rows such as “(USD)” and rows of column numbers, which are dropped.
Why “Q1 2026 / Units” and not just “Units”?
Because otherwise the table has duplicate column names. You can rename any column, and saved layouts remember your names for the next file.
Does it work with PDF tables too?
Yes. Header lines above the columns of a PDF table are combined the same way, including years written above month names.

Related tasks

See all tools