Hello,
I found several topics on merging rows, however they all seemed to be different to what I am trying to accomplish.
I am trying to merge rows for which the following two conditions are true:
Same lot number
Months column has the value 0
So for example in the below dataset, rows 1&2, rows 5&6, and rows 9&10 would be merged into 3 rows.