Populate table from database with 2 conditions

Hello guys,

Hope you will be able to give me a hand. I have a pretty vast database which I populated through VBA from a certain number of worksheets. I now need to create a table which shows min, max and average for each location given x, y or z condition. So far I only approached it by creating a secondary table with each range address and then using INDIRECT, but this would require extra work on the database (insert a function to sort out locations alphabetically and within each Range.Location sort out by conditions (note. A, B and C are not in alphabetic order)) and is also very ugly.
I was wondering whether you had any more elegant ideas?
I attached a sample example of my spreadsheet hoping it will help!

Thank to whoever will spare the time to help me.

Best,
Carlo

See Pivot Tab

guys thank you so much, this seems perfect!

only have on question; in my database I have few ranges (location+conditon) that do not have any data available but when the Pivot Table calculates min and max it returns 0 rather than an error or "no data". can I change this somehow?