Hello Microsoft Community,
I'm currently working with data in Excel and I'm facing a challenge that I hope someone can assist me with.
I have a dataset that displays debit and credit entries on separate lines like this:
Date | Account | Debit ($) | Credit ($)
------------------------------------------------
2023-10-01 | Account A | 100 | 0
2023-10-01 | Account B | 0 | 100
2023-10-02 | Account A | 50 | 0
2023-10-02 | Account B | 0 | 30
2023-10-02 | Account C | 0 | 20
However, I need to combine the debit and credit entries for each account into a single line to get a ledger-like format, like this:
Date | Debit Account | Credit Account | Amount ($)
------------------------------------------------
2023-10-01 | Account A | Account B | 100
2023-10-02 | Account A | Account B | 30
2023-10-02 | Account A | Account C | 20
Is there a way to achieve this in Excel? Any guidance or suggestions on how to approach this problem would be greatly appreciated.
Thank you in advance for your help!
