Jun 04 2021 08:24 AM
My data set includes the “from” and “to” side of a transaction. Both sides of a transaction are represented by the same reference number. I am only interested in viewing transactions “from” Warehouse “to” Center. How can I specifically identify only the matching “from” warehouse “to” center transactions? By matching I mean a “from” and “to” transaction with the same reference number. For example in the data set below I would like to identify both sides of reference # 1, 2 & 6. Any thoughts?
Reference# | From | From Amt | To | To Amt |
1 | Warehouse | -340.3 | ||
1 | Center | 340.3 | ||
2 | Warehouse | -476.42 | ||
2 | Center | 476.42 | ||
3 | Warehouse | -1616 | ||
3 | House | 1616 | ||
4 | Warehouse | -175.78 | ||
4 | House | 175.78 | ||
5 | Store | -1616 | ||
5 | Work | 1616 | ||
6 | Warehouse | -362.4 | ||
6 | Center | 362.4 | ||
7 | Store | -168.15 | ||
7 | Work | 168.15 | ||
8 | Store | -168.15 | ||
8 | Center | 168.15 | ||
9 | Park | -168.15 | ||
9 | Center | 168.15 |
Jun 04 2021 08:53 AM
Jun 04 2021 08:56 AM