Merging non-unique entries into a single unique entry

Hello,

I'm working with a dataset of about 20 columns and 40,000 rows. The columns include a unique identifier (ID1), a non-unique identifier (ID2), and then binary variables. For example, a small section of my dataset would look like this:

ID1---------ID2-----------Red----------Green------Blue--------Orange

JS------John Smitha-------0--------------1-----------1------------0
JS------John Smithb-------1--------------1-----------0------------0
MB------Matt Brown-------0--------------1-----------1------------1
DB------David Book-------0--------------0-----------0------------1

I need to combine the ID2 entries according to their unique ID1 in a way that combines a 0 and 1 as 1, a 0 and a 0 as 0, and a 1 and a 1 as 1. For example, the new table should be as follows:

ID1-----Red----------Green------Blue--------Orange

JS--------1--------------1-----------1------------0
MB-------0--------------1-----------1------------1
DB-------0--------------0-----------0------------1

I would like to avoid doing this manually, as there are about 5,000 non-unique entries that need to be combined.
Thanks for your help!

Thank you! I will do some reading up on pivot tables, and if I can't make it work I'll move on to the VBA code. I'll post back with progress.

@Craig K.

Thank you! The pivot table worked perfectly. I will mark the thread as solved.

I do, however, have a related question for which I would appreciate your help. I can make a new thread if needed.

I have other variables that are not simply encoded as "0" or "1". How would you change the Value Field Settings to Summarize:

Insurance: "Y" or "N" so that "Y" is the overriding value? Or so that some third value "P" is reported? (In cases of discordant entries)
Race: "W" or "U" or "B" or "HW" so that "U" is replaced by the other values. (In cases of discordant entries)


Thanks for your help! I'm sure I will have more questions

Thanks. For now I will most likely pursue workarounds by converting text to number and back again. I have no knowledge of Excel VBA, but I may have to learn about it in the future.