Multi-Row Formula Case: Repeat ID multiple lines with several criteria

[grromerro]

Hi Community,

I am new using the Multi-Row Formula and I think that is the way to go to get the results I need.

I need to keep the original ID of a product for each code number and sequence number. In the example below, the product ROM-300 has the ID 1239779 for the Code 234. This should be the same number in all lines for sequence 0, 1, and 2. But since sequence 2 was a new line, the data base bring another ID (120451) and I need to keep the same original ID (1239779) for all records.

Please see below how it is now and how it should be after appliying the corresponding formula.

Could you help me configure the tool (if that is the right to use) please? 

Thank you!

GR

[aatalai · Accepted solution]

@grromerro got what you are looking for but without using the multi row formula, let me know if it is of any use (did it via sample, and join)

[aatalai · Accepted solution]

here it is with the multi row formula

[grromerro]

Thank you so much for your solution. It seems to be working fine!!!