Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
User | Count |
---|---|
11 | |
7 | |
5 | |
5 | |
4 |
User | Count |
---|---|
16 | |
14 | |
8 | |
6 | |
6 |