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.

[atcodedog05 · Accepted solution]

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 : )

[Luke_C · Accepted solution]

Hi @Fescobar 

I agree with @atcodedog05 , not fully clear on the requirements but I'm going with the two vendor fields being the same.

@atcodedog05 I don't think the lowercase is needed for whatever reason, seems to work fine either way. I always forget which things are case sensitive.

[Fescobar]

THANK YOU SO SO VERY MUCH .@atcodedog5 and .@Luke_C this worked like a charm!!

[atcodedog05]

Hi @Fescobar 

Happy to help : )

Gentle note, you are allowed to mark multiple replies as solutions. 😅

[Fescobar]

Thank you! I have marked your reply as a solution as well.