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

Attached Files

Test.xlsx (22.7 KB, 11 views)