Power Query Problems

How to Combine Multi-Row Bank Transaction Descriptions into One Row in Excel

Olivia MillerOlivia Miller Nov 13, 2026 869 views

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 start

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.

Solution 1Recommended

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.

1
Load the bank transaction range into Power Query

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.

2
Fill down the transaction key columns

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.

3
Group rows by the transaction reference

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.

4
Combine the grouped description text

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.

5
Close and load one row per transaction

On the Home tab, click Close & Load To, choose Table, and select New worksheet or Existing worksheet to output the consolidated transaction list.

Refreshing the query: After you save the query, update the source table or file path and click Refresh to repeat the fill-down and grouping steps automatically.
Free Microsoft Office alternative

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.

Opens and saves .xlsx bank statement workbooks without converting your filesFree to use with a familiar ribbon interface similar to Excel, so you can review, filter, and edit transaction data quicklyLightweight installation that runs smoothly while working with large exported bank statementsPreserves common Excel formulas and formatting so you can continue cleaning transaction data after export
microsoft office alternative - wps office

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.