I am about to import data from excel to erp system.
The thing is that it would be more sufficient having one transaction (inside erp system) for rows with similar values in column A and D.
E.g. there would be only two transactions instead of four in this case. One for rows 1,2,4 and one for row 3.
How can I approach this situation? Should I create temprory data table to put rows with similar values in columns A and D and then pass it onto erp / should iterate over each row and “memorise” the value in column D from where i start and then compare value in the new row with that “memorised” one?
Appreciate any advice