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!
解決済! 解決策の投稿を見る。
Thank you so much, @deviseetharaman !!!!!