Greetings!
I have a large dataset, a snippet of which looks like this:
![Andy8_0-1662918693824.png Andy8_0-1662918693824.png](https://community.jmp.com/t5/image/serverpage/image-id/45362i1E6FC58ABFF3C6FB/image-size/medium?v=v2&px=400)
I want to take the mean of each of the 7 P-P and RMS columns that have the same DateTime. Since there are 4 unique DateTimes in the data, this would result in a table with 4 rows. Ideally SN column would be preserved. I suspect Tables->Summary may hold the key, but I can't get it to do what I want. I have been able to get the result I want using Formula columns, but this is a frequent need with lots more columns and Formula columns get cumbersome quickly.
Thank you!
Andy