Changing a boolean string to multiple records (or vice versa)

[TyeReece]

I receive an excel file each week that has the race of individuals noted as a single six character Boolean string (e.g., 100000 or 011000 or 000111 etc.). Each 1 or 0 is a "yes" or "no" to the corresponding races. First digit "White", second "African American" etc. As you can see, an individual may have all "0"s, all "1"s or any combination. Our database, which I use the file to update, has race as multiple records per individual. I would like to automate the updating of this process. Is it easier to change the Boolean string into multiple records or combine the multiple records in our database to a Boolean string? And how would you go about it?

 

[Special-K99]

Dunno what youre asking for.

Does this help?

There are only 64 possible outcomes of your Boolean string.
If you use BIN2DEC() on the Boolean string you can use a VLOOKUP to identify which races have 1s against them.