I need to create the example file attached without the last two columns that describe the stores.
Basically I need to define stores based on whether or not they sold a specific product. I also need to define the store based on how many times it sold that specific product.
The example is the output as I'd like to have it, the other file is what I've got so far.
Any help would be appreciated.