I have a data set where each of our customers can have one or more than one of our 10 products. The data right now is organized like this:
Column Names: Customer name/product 1/product 2/ product 3/....
Entry: Emma/Y/N/N...
I need an easy way to not only see how many people have product 1, but how many of those people have product 1 and 2. I just cannot figure out how to organize my data to help me do this. I've tried pivot tables, but it's just not combining the data in a helpful way.
I'm really looking forward to your advice!
Column Names: Customer name/product 1/product 2/ product 3/....
Entry: Emma/Y/N/N...
I need an easy way to not only see how many people have product 1, but how many of those people have product 1 and 2. I just cannot figure out how to organize my data to help me do this. I've tried pivot tables, but it's just not combining the data in a helpful way.
I'm really looking forward to your advice!