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
