Concatenate every 2 rows into 1, based on account numbers

[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

[binuacs]

@Kavya132017 One way of doing this

[OllieClarke · Accepted solution]

Hi @Kavya132017 

Here's how I'd do this:

I've made the recordId pair all the rows - as I think this is what you're after - ideally there'd be a combination of fields which gives that unique grouping, but this gives the right output

Ollie

[Kavya132017]

Thank you so much OllieClark, that worked.

[Kavya132017]

Can you please help me,How can I get other related columns into the output data maintaing the same logic? updated the sheets and attached