Setting Fixed Variables in a Table?

I am trying to keep track of the products we sell but finding it difficult to monitor since my sales data drive what I see in my table. For example, if we sell 20 products, but the specific retailer ...