To remove repeated header rows from a PDF statement that you converted to Excel, filter the Date column for the heading word, delete the visible rows and clear the filter. If you repeat this every month, Power Query can drop those rows as one saved step instead.
Why does the heading appear on every page?
Statement PDFs print Date, Narration, Debit, Credit and Balance at the top of every page so each printed page reads on its own. A converter has no idea that the second and third copies are decoration, so it hands them to you as ordinary rows. A six-page statement leaves six heading rows scattered through your transactions.
They are more than an eyesore. A SUM quietly skips them, but a pivot table lists the word Date as if it were one of your dates, sorting throws them to the top or bottom, and a count of rows is off by the number of pages.
Method one: filter and delete the visible rows
- Click any cell in your data and press Ctrl+Shift+L (or use Data, then Filter) to switch on the filter arrows.
- Open the arrow on the Date column, untick Select All, and tick only the heading word, which will be Date or whatever your converter wrote. Press OK. You now see the real heading on row 1 and every repeated copy.
- Select the row numbers of the repeats only. Click the first repeat's row number, then hold Ctrl and click the others, or hold Shift and click the last one if they sit together. Do not include the genuine heading row.
- Right-click a selected row number and choose Delete. With a filter on, Excel removes only the visible selected rows.
- Clear the filter from the Data tab. Every transaction row returns and the repeats are gone.
What if the heading is split over two rows or hides in the Narration column?
Some converters break a long heading such as Withdrawal Amt. across two lines, or put page footers like Page 2 of 6 into the table. A filter on one word will miss those. Instead, test what a real transaction row looks like. If your Balance column is column E and holds true numbers, put this in a helper column on row 2 and fill down:
- =IF(ISNUMBER(E2),"keep","drop")
Filter the helper column for drop, glance down the list to confirm only headings and footers are there, then delete those rows. This works only when the balances were converted to real numbers, so first check that =COUNT(E2:E500) matches the number of transactions you expect.
Can Power Query remove them in one step?
Yes, in Excel 2016 and later. It is worth the ten minutes if you tidy a statement every month, because the cleanup is saved and replays on refresh.
- Click inside the data and choose Data, then From Table/Range. Tick that the table has headers.
- In the Power Query window, open the filter arrow on the Date column and untick the heading word. If you see blank or null entries from page gaps, untick those too.
- Only then change the Date column to a date type. Done in the other order, the word Date becomes an error value and the filter cannot see it.
- Choose Close and Load. Next month, paste the new conversion into the source and use Refresh All.
If you prefer to see the formula behind the click, the filter step reads =Table.SelectRows(#"Changed Type", each [Date] <> "Date"), where the step name in your query may differ.
How do I check that nothing real was deleted?
Use arithmetic. Say a statement has 4 pages and 120 transactions. After conversion you have 4 heading rows plus 120 transaction rows, 124 in all. You keep the first heading and delete 3 repeats, so 121 rows remain: one heading and 120 transactions.
| Check | Formula | Expected in this example |
|---|---|---|
| Transaction rows left | =COUNTA($A$2:$A$500) | 120 |
| Heading words left in data | =COUNTIF($A$2:$A$500,"Date") | 0 |
| Rows with a balance | =COUNT($E$2:$E$500) | 120 |
If the first number is lower than the count printed on your statement, a transaction went with the repeats. Go back to the copy and compare.
Before you rely on the cleaned sheet
- Sort by the Date column and confirm the order still follows the statement.
- Compare the opening balance, the total of credits and the total of debits with the summary on the statement.
- Look for carried-forward or brought-forward lines at page breaks. They carry a balance but are not purchases, so mark or remove them.
If you would rather skip the heading cleanup altogether, SpendixAI takes PDF, CSV or Excel statements and shows the rows for your review before anything is saved. Unusual layouts may still need a careful look, so keep the statement's own totals handy either way.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


