multiple data files from multiple measurements, averaging the measurement results

[#1]

Dear Community,

I have data files from n multiple measurements (x, y, z, Mx, My, Mz) as separate jmp tables. They are identical regarding the measurement points (x, y, z), i.e. they have the same no. of cols and rows.

table 1 = 1. measurement: x, y, z, Mx.(1), My.(1), Mz(1)

table 2 = 2. measurement:  x, y, z, Mx.(2), My.(2), Mz(2)

...

table n = n. measurement:  x, y, z, Mx.(n), My.(n), Mz(n)

I want to do calculations like Mx.avg = mean(Mx.(1), ... Mx.(n)) and create a result table  like x, y, z, Mx.avg, My.avg, Mz.avg.

Any hints?

Thank you!

[#2]

Typically one needs to have all of the data that are to be summarized to be in a single data table.  Then platforms such as Tabulate or Summary will be able to summarize across all of the data.  

JMP can easily put the tables together.

The notation you are using to describe you data tables is somewhat confusing to me.  Would you be able to provide a couple of examples of actual data tables?