Hello,
It's my first post here. I'll be rather quick and straight forward.
I have three tables, relatively similar. I want to create a pivot table or some similar solution, to display their data. See pictures below.
First pictures are the tables and their data and how they would tie in into the -concept- table/pivot table. The second is the concept/structure for the pivot table/table.
To make a pivot table you'd need to create relationships between these tables, which I find somewhat hard to do. Any help will be highly appreciated.
Concept.png
conceptpivot.png
PD. I can really make some macro to do this but I'd really would like to have a codeless solution.
Bookmarks