Hi
I have a source table as follows:
I want to summarise it to look like this:
Any help would be appreciated - if I haven't explained it clearly let me know.
Thanks
I have a source table as follows:
Entity 1 | Entity 2 | Amount |
abc | jkl | 150 |
def | mno | 250 |
ghi | pqr | 350 |
jkl | abc | -100 |
mno | def | -200 |
pqr | ghi | -300 |
abc | mno | 350 |
mno | abc | -295 |
def | jkl | 45 |
jkl | def | -75 |
I want to summarise it to look like this:
Entity 1 | Entity 2 | Amount1 | Amount2 |
abc | jkl | 150 | -100 |
def | mno | 250 | -200 |
ghi | pqr | 350 | -300 |
abc | mno | 350 | -295 |
def | jkl | 45 | -75 |
Any help would be appreciated - if I haven't explained it clearly let me know.
Thanks