SKU with same name but different location

Hi All, 

Running into an issue where there is an Item(#) that is my main dimension and relationship but it can appear in 2 locations (BPs). Is there a way to have logic that matches Item# with a BP? unsure if merge or concatanate will work because the users do not want a combinded record.  

Example of issue: 

Data Set that is being fed into a larger set: 

the highlighed is the concate ID w/ the correct BP (column 2) as the last 2 digits. However, the relationships connect item (column 3). 

Any advice or assistance is greatly appreicated.