Forum Discussion
Jeremy1565
Oct 07, 2022Copper Contributor
Combine bank statement entries
Hi, I have downloaded my monthly banks statement as an excel document, and I currently have a table that has 3 columns: Narration (The business name) Debit Credit I want to be able to comb...
Lorenzo
Oct 07, 2022Silver Contributor
Hi Jeremy1565
A classic PivotTable does it easily (avail. in attachement). Otherwise...
With Power Query, Group by [Narration] and do an aggregate Sum or [Debit] and an aggregate Sum of [Credit]:
Sample attached