duplicate rows per condition

[Nazik_Ghukasyan]

Hello team

I read some solution by using Generate row, Record ID tools etc but couldn't find an answer for my question.

attached is the database where I have following structure

Debit Account    Credit Account   Debit Amount   Credit Amount

155489                143987                 11,000               11,000

I would like to duplicate each row by creating only one column Account and leaving corresponding amount only under debit or credit

Account     Debit Amount   Credit Amount

155489        11,000                0

143987         0                        11,000

do you have any idea to to come to this result?

thanks

Nazik

[Luke_C · Accepted solution]

Hi @Nazik_Ghukasyan 

Here's one approach you could use:

[Nazik_Ghukasyan]

@Luke_C thank you this is very very helpful 🙂