Linking Two Columns With the Same Values

Fescobar

Hello My Fellow Designers,

I hope that you're all doing well.

I am stuck...and I am in need of assistance.  I have the attached data set (Master 😎 which contains product numbers from one of our partners as well as our product numbers along with our prices.  Currently I have a one to many relationship between columns B and F (Sample 1).  I need to be able to display the as shown on the Final Result attachment, so basically, a 1:1 relationship (Final Result).  I have cracked my noggin all morning long and I cant see how I can get this done.  I am certain that it is a simple solution, but I can't see it.  

The assistance will be AWESOMELY appreciated.

Sample 1.png

Final Result.png

Master (8).xlsx

atcodedog05

Hi @Fescobar 

I just got a rough understanding.

Scenario -1: sc_vendor_name(2)=sc_vendor_name

Scenario -2: Last row of SKU and sc_vendor_name(2)

Hope this helps : )

SKU.yxmd