Filter/Group Multiple Columns From Different Tables

[left4pie2]

I'm trying to show avg length, width and thickness by the item being face or a back in the matrix below. My problem is the length, width, and thickness values come from 3 different tables. Each of these tables has it's own Face/Back column that tells if the measurement is for a face or a back. 

You can see that because of this I have 3 face/back columns in the matrix. I'd like to make this into 1 column. I tried to do this by making a face/back table and linking it with a one to many relationship but it only lets me do that to one table at a time. Is there any way to merge/group these three columns?

Thanks!

[AlexisOlson · Accepted solution]

Add a column to each table that defines what dimension it is (Length/Width/Thickness) and rename the (mm) column to a standard one across all 3 tables so that you can append them into a single table that looks more like this:

This will make building visuals significantly easier.

[left4pie2]

Yeah that makes this way simpler. Thanks!

[left4pie2]

Here's an example of what each table looks like. This is the length table.