I have a sheet that looks like this:

name number preference1 preference2 preference3
me 123 X X
you 246 X X
other 789 X

What I need to do, is:

1. Change the X to the header name which I think I can do with IF
2. For each additional X for that name, create a new row that has the name,
number and only that preference listed but in the same column it's in.