combine multiple values

[#1]

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!

[#2 · Accepted solution]

Use 

     Tables=>Summary