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!
Solved! Go to Solution.
Thank you so much, @deviseetharaman !!!!!