Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Hello, @awaheedm- do you always have the same pattern when only one debit and one or more credit entries back to back in line for the same date? Or the following:
Account A DT 60
Account B DT 40
Account C CR 70
Account D CR 30
is also possible for the same date?