Hi,
I have a data set which contains product_id's and a number of booleans where each row has a boolean set to true.
I have multiple rows with the same product_id and each row has different booleans set to true
is there a way to group these rows in to one row per product_id?
example
prod_ID bool1 bool2 bool3 bool4
A 0 0 1 0
A 0 0 0 1
B 1 0 0 0
B 0 0 0 1
I would like to get a date set which looks like
A 0 0 1 1
B 1 0 0 1
Thanks