How to make multiple line items into a single line item?

[crazybeauti_ful]

Hi,

In my attached screenshot, I am getting 4 line items for a single account. The txn colums are the individual txns comprising the sum columns. How do I make it like this?

  Sum A          Sum B         Sum C          Txn A          Txn B         Txn C

29944.06      -5240.21       2994.41       14972.03    -5240.21     2994.41

29944.06      -5240.21       2994.41       14972.03         0                0

Or something like that. Basically, I need to delete duplicate rows as much as possible. Some accounts have 72 line items but most are just duplicate lines.

Thank you!

[deviseetharaman · Accepted solution]

Updated WF for the above requirement

[crazybeauti_ful]

Thank you so much, @deviseetharaman !!!!!