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!