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

%3CLINGO-SUB%20id%3D%22lingo-sub-2416597%22%20slang%3D%22en-US%22%3EIdentifying%20the%20same%20reference%20number%20on%20two%20sides%20of%20a%20transacation.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2416597%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20data%20set%20includes%20the%20%E2%80%9Cfrom%E2%80%9D%20and%20%E2%80%9Cto%E2%80%9D%20side%20of%20a%20transaction.%20Both%20sides%20of%20a%20transaction%20are%20represented%20by%20the%20same%20reference%20number.%20I%20am%20only%20interested%20in%20viewing%20transactions%20%26nbsp%3B%E2%80%9Cfrom%E2%80%9D%20Warehouse%20%E2%80%9Cto%E2%80%9D%20Center.%26nbsp%3B%20How%20can%20I%20specifically%20identify%20only%20the%20matching%20%E2%80%9Cfrom%E2%80%9D%20warehouse%20%E2%80%9Cto%E2%80%9D%20center%20transactions%3F%20By%20matching%20I%20mean%20a%20%E2%80%9Cfrom%E2%80%9D%20and%20%E2%80%9Cto%E2%80%9D%20transaction%20with%20the%20same%20reference%20number.%20For%20example%20in%20the%20data%20set%20below%20I%20would%20like%20to%20identify%20both%20sides%20of%20reference%20%23%201%2C%202%20%26amp%3B%206.%20Any%20thoughts%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22416%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3EReference%23%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3EFrom%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3EFrom%20Amt%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3ETo%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3ETo%20Amt%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3EWarehouse%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E-340.3%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3ECenter%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E340.3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3EWarehouse%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E-476.42%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3ECenter%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E476.42%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3EWarehouse%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E-1616%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3EHouse%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E1616%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E4%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3EWarehouse%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E-175.78%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E4%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3EHouse%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E175.78%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E5%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3EStore%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E-1616%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E5%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3EWork%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E1616%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E6%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3EWarehouse%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E-362.4%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E6%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3ECenter%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E362.4%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E7%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3EStore%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E-168.15%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E7%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3EWork%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E168.15%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E8%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3EStore%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E-168.15%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E8%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3ECenter%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E168.15%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E9%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3EPark%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E-168.15%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289.5px%22%3E9%3C%2FTD%3E%3CTD%20width%3D%2293.9167px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22105.033px%22%3ECenter%3C%2FTD%3E%3CTD%20width%3D%2262.8833px%22%3E168.15%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2416597%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2416726%22%20slang%3D%22en-US%22%3ERe%3A%20Identifying%20the%20same%20reference%20number%20on%20two%20sides%20of%20a%20transacation.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2416726%22%20slang%3D%22en-US%22%3EIs%20this%20really%20the%20layout%20you%20get%3F%20Or%20do%20you%20actually%20have%20a%20different%20setup%3F%3C%2FLINGO-BODY%3E
Occasional 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