How can i extract row values from duplicate column values

Hello @sathwik_pindi

Here in DT2 you hqve duplicate invoice number. So you are confirming invoice number 60003 and quantity 150 should extract for item code 50123?

If it is unique we can do. Otherwise you need to clarify how this mapping is happening.