326588_en-US

liliconcom

Merging Rows based on two column conditions

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.

ScriptingRe: Merging Rows based on two column conditions

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.