I am trying to replicate the scenario ,where i want to get the Materiel location based on condition - like Materiel type - "F" or "T".
The value of the Material Locations in 2 to 3 rows - 1 row contains the materail type "F" and other Row contains Materiel Type "T".
I want to show each row which populate the data based on Material type.
Attaching the sample data. which contains 2 tabs - Input and expected output.
Can you please help.
Is there another field (like Order No ?) that can be used to join the data together ?
I think I can do it based on the data that you have, but it won't be perfect all the time - like how does the last line (quantity = 10) link to the -100 row ? (I just don't understand that)