Broken PDF columns
How Do I Fix a Bank Statement Pasted into the Wrong Excel Columns?
Reviewed 12 September 2026
Short answer
Short answer
Preserve the original paste, then identify a reliable transaction boundary such as the date at the start of each row. Use Power Query to split only on delimiters that are genuinely consistent, join continuation descriptions before splitting amounts, and convert the final date and amount fields explicitly. If spacing changes from row to row, stop using fixed-width splitting because PDF spaces are visual positions, not dependable column separators.
A PDF can look like a table while containing no spreadsheet cells at all. Copy and paste reveals the document's hidden text order, not necessarily its visible columns.
Rebuild rows before trying to split columns
Find what reliably starts a transaction. It may be a date, but date-looking references inside descriptions mean that rule still needs review. Continuation lines should be joined to the transaction above before amount columns are separated.
Do not use a merchant word to decide whether an amount is a debit or credit. Use the source column, a printed sign or consecutive running-balance changes.
Step by step
- 01
Keep the raw paste
Duplicate the sheet so you can always compare the repair with the original text order.
- 02
Mark transaction starts
Identify a pattern that starts real rows and review date-like text inside descriptions.
- 03
Join continuation lines
Attach wrapped references and descriptions to the correct transaction.
- 04
Split and type columns
Create Date, Description, Debit, Credit and Balance fields, then set dates and amounts to real values.
Checks before you rely on the spreadsheet
- Each transaction occupies one row.
- Descriptions were joined before amount parsing.
- Amounts are numeric rather than text.
- Debit and credit direction comes from statement values.
Questions people ask
Why does a PDF paste into one Excel column?
PDF text is positioned on a page rather than stored in spreadsheet cells, so the visual columns may disappear during copy and paste.
Can Text to Columns fix it?
Only when the delimiter is genuinely consistent. Variable spaces and wrapped descriptions can make Text to Columns silently misalign values.
What if every row needs a different repair?
That is a strong signal to use the original bank export or a parser built for the bank instead of maintaining a fragile manual split.