Identifying the same reference number on two sides of a transacation.

Copper Contributor

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#           FromFrom AmtToTo Amt
1Warehouse-340.3  
1  Center340.3
2Warehouse-476.42  
2  Center476.42
3Warehouse-1616  
3  House1616
4Warehouse-175.78  
4  House175.78
5Store-1616  
5  Work1616
6Warehouse-362.4  
6  Center362.4
7Store-168.15  
7  Work168.15
8Store-168.15  
8  Center168.15
9Park-168.15  
9  Center168.15
2 Replies
Is this really the layout you get? Or do you actually have a different setup?
Thanks for the response. This is the actual layout that I get