Concatenate rows based on credit & debit accounts

[Kavya132017]

I have a data where all the debit account numbers are same("1" in attached data), and there are 2 different credit account numbers("2" & "3" in attached data). There is always a pair for each transaction.Single person can have multiple transactions of same amount too.

example: 1&2, 1&3.

Debit & Credit are currently stored in 2 different rows. I need to merge them into single row for each transaction, by identifying the pairs.

Attached is sample data & required output

[ShankerV]

Hi @Kavya132017 

One way of doing this.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Kavya132017 

Step 1: Input

Step 2:

Step 3:

Many thanks

Shanker V