cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
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.