I have a column in my data that has multiple values separated by a space. So I can use Prep to do a custom split using space as a delimiter but since the values in the cell are in random order the split doesn't add value. In my sample dataset I used directions to demonstrate what I'm talking about. One cell could be "N NW SE" and another could be "SE N NW"
Ideally I could split this column into all of the possible choices (N, NE, E, SE, S, SW, W, NW) and have the data in the cells be Yes/No.
I appreciate any help I can get on this, thank you!
