Combining several tables

[nn992]

I have 6 tables like this. each has 72 rows. Is there an option to represent all of those as 1 table with average values of all 6 as content.

So the output would be same columns and rows as this one, but content should be averages of all tables.


Is it possible and how?

 

[ranman256]

Microsoft Access can show them all in 1 union query.

 

[nn992]

thanks, but I am looking for solution by Excel