Hi there m
you can create a pivot table using your original table that will show you the count of each region for each product.
You can also have a graph of this pivot table
You can also use that pivot table to create a table almost exactly as the one you created manually.
I attach an example. Sorry for the greek in the worksheet but my Excel is greek edition
