topic Re: Merging Rows based on two column conditions in Discussions

Merging Rows based on two column conditions

DanAlexander — Fri, 09 Jun 2023 23:41:33 GMT

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.

txnelson — Mon, 26 Oct 2020 20:36:31 GMT

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.

DanAlexander — Tue, 27 Oct 2020 15:16:35 GMT

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