Hi Everyone,
I have a situation of credit & debit amount per each account filled in 2 rows.I want to club it into a single row.How can I do it?
Example:
Expected output:
Attached sample data.
Any help is appreciated.Thank You
Hi @Kavya132017
A very quick way is to use the Summerise tool:
Grouping by Account then summing Credit and Debit columns. This only works though if you only have one value per account (unless you want to sum them!)
Hey David,
Thanks for the quick response. I don't want to sum the credit and debit amounts. Each account may have various transactions in different months.I want all of them too be separate.
@Kavya132017 Another option using Transepoe and Cross tab tool
Hi, @Kavya132017
Here is another option.
I hope you find it helpful - Cheers!
Hey Robert,
I've tried the Join solution mentioned. It's giving cartesian product which increases the count of records. I don't want that. How can I get rid of it
