Hello,

I am trying to take a set of records that include a name followed by another cell that is a list of attributes seperated by ; 's. I have included a file with what I'm trying to do.

The goal is to seperate the 2nd column into 0's and 1's based on whether or not the name has that attribute.

There will always be a name called dummy that has every possible attribute so the # of columns in the output sheet is dynamic.

Suggestions??

Thanks