cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
DanAlexander
Level III

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.

2020-10-26 16_18_18-Test_data - JMP.png

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Merging Rows based on two column conditions

All you need to do is to run

     Tables=>Summary

and select the following settings

combine.PNG

The data table produced will have the results you want.

Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: Merging Rows based on two column conditions

All you need to do is to run

     Tables=>Summary

and select the following settings

combine.PNG

The data table produced will have the results you want.

Jim
DanAlexander
Level III

Re: Merging Rows based on two column conditions

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