I have a table that provides multiple customer records with multiple flags (1,0) for product items, however only 1 flag is present per record. I'd like to create a single record with the customer id and all of the product flags Have: Customer ID Bananas Apples Cherries Oranges 123 1 0 0 0 123 0 1 0 0 123 0 0 0 1 Want: 123 1 1 0 1
... View more
