Fill rows with data from existing rows

[Kavya132017]

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

[davidskaife]

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!)

[Kavya132017]

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.

[binuacs]

@Kavya132017 Another option using Transepoe and Cross tab tool

[RobertOdera]

Hi, @Kavya132017 

Here is another option.

I hope you find it helpful - Cheers!

[Kavya132017]

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

[davidskaife]

Hi @Kavya132017 

Assuming your debit/credit amounts will always be equal you could use a filter tool after the join to filter when Credit = Debit: