Here's what I did:
1. Name each of the three tables using Formulas | Name Manager.
2. Go to Data | Get Data | From Other Sources | Blank Query.
3. Use the following M Code, starting with Excel.CurrentWorkbook():
4. Close & Load To ... | PivotTable Report.
5. Set up the pivot table fields as required.
If you look at my sample file and go to Data | Queries & Connections, you will be able to launch the query I created (called Pivot) to see the above.
You can configure the pivot table to suit yourself, of course.
Your attachment is invalid, so I don't know what you are trying to show me.
Bookmarks