cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar

combine multiple values

Hey,

I have a question about how to combine double reporting in JMP:

lets say that I have an output of 3 colums: row_index, column_index and value.

and for some reason the out put has double reporting issue of row and columns, for example:

Row Column Value

  1        1          3

  1        2          5

  1        3          7

  1        3          7.2

 

Notice that I have a double reporting in the last row (2 times 1,3).

Is there a way to combine them into 1 row and make the value an average of them?

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: combine multiple values

Use 

     Tables=>Summary

txnelson_0-1652841705672.png

txnelson_1-1652841743203.png

 

Jim

View solution in original post

1 REPLY 1
txnelson
Super User

Re: combine multiple values

Use 

     Tables=>Summary

txnelson_0-1652841705672.png

txnelson_1-1652841743203.png

 

Jim