Merging Rows based on two column conditions

[#1]

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.

[#2 · Accepted solution]

All you need to do is to run

     Tables=>Summary

and select the following settings

The data table produced will have the results you want.

[#3]

Ah thank you for this solution, I did not think to use the Mean() statistic in the summary table.