How to Combine Multi-Row Bank Transaction Descriptions into One Row in Excel
Question details
Consolidate bank transaction descriptions that span multiple rows into a single row per transaction using Excel Power Query or Microsoft 365 dynamic-array formulas.
- Product
- Microsoft Excel (Power Query and Microsoft 365 dynamic arrays)
- Device & OS
- not provided
- Scenario
- A user receives a bank export in which each transaction uses a reference row followed by continuation rows for the description, and needs a clean one-row-per-transaction dataset for reconciliation or reporting.
- Observed behavior
- The exported bank data repeats transaction reference values only on the first row and leaves related cells blank on continuation rows, splitting the description across multiple rows.
Before you build the query or formula, confirm that the bank export includes at least one stable transaction key, such as a reference number or transaction date, on the first row of each transaction and that continuation rows can be linked to that key.
Use Power Query to Group and Combine Bank Transaction Descriptions into One Row
Use this method when you want a repeatable, refreshable transformation for recurring bank exports; Power Query can fill down key fields and merge the related description rows into one row per transaction.
Power Query groups rows by the transaction key, copies key values into blank continuation rows, and combines the related description text. This is generally easier to refresh and maintain when you receive new bank statement files.
In Excel, select any cell in the bank transaction range, go to the Data tab, and click From Table/Range to load the data into the Power Query Editor.
Select the transaction reference or date column, right-click the column header, and choose Fill > Down to copy the first-row value into blank continuation rows.
On the Transform tab, click Group By; in the Group By dialog choose Advanced, select the transaction key as the grouping column, add a new column named Combined Description, set Operation to All Rows, and click OK.
In the formula bar, edit the generated Table.Group formula so the aggregation uses Text.Combine([Description], " ") on the grouped description column, then click the check mark to apply it.
On the Home tab, click Close & Load To, choose Table, and select New worksheet or Existing worksheet to output the consolidated transaction list.
Use Microsoft 365 Dynamic-Array Formulas to Combine Transaction Descriptions
Use this method when you cannot use Power Query and have Microsoft 365 functions such as LET, SCAN, FILTER, REDUCE, VSTACK, and TOROW; it builds a calculated result directly on the worksheet.
Use WPS Office as a Free, Lightweight Alternative for Bank Transaction Workbooks
Power Query and Microsoft 365 dynamic arrays are Microsoft Excel features. WPS Office does not include Power Query, but WPS Spreadsheets opens and edits your Excel bank files, preserves familiar formulas and formatting, and gives you a free, lightweight way to inspect, clean, and share transaction data without an Office 365 subscription.

Frequently Asked Questions
Can I combine bank transaction descriptions in WPS Spreadsheets without Power Query?
WPS Spreadsheets can open the .xlsx bank export and help you review, filter, and edit the data, but it does not include Excel’s Power Query. For a fully automated one-row-per-transaction transformation, run the Power Query steps in Microsoft Excel.
Why does my bank statement split one transaction across multiple rows?
Many bank export formats place the transaction reference, date, and amount on the first row and then continue the description or memo on additional rows. Blank reference cells indicate that the rows belong to the same transaction.
Which Power Query operation combines text from multiple rows?
Use Group By with the transaction key, then edit the generated formula to use Text.Combine on the description column. You can also start with the All Rows aggregation and later transpose or merge the grouped table.
Do the Microsoft 365 dynamic-array formulas work in WPS Office?
Functions such as SCAN, REDUCE, and VSTACK are part of Microsoft 365 Excel and may not be supported in WPS Office. Use them in Microsoft 365 Excel, or choose the Power Query route in Excel for reusable bank statement cleanup.
How do I refresh the combined bank data when I receive a new export?
In Excel, replace the source table or update the file path, then open the Queries & Connections pane, right-click the query, and choose Refresh. Power Query repeats the fill-down and grouping steps automatically.




