L
Lynn Bales
I posted this initial in newuser area, but I suppose that wasn't appropriate
for what I needed to do. 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. 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.
2. Change the X to the header name which I think I can do with IF
So the results would look like:
name number preference1 preference2 preference3
me 123 preference1
me 123 preference2
you 246 preference2
you 246 preference3
other 789 preference2
for what I needed to do. 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. 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.
2. Change the X to the header name which I think I can do with IF
So the results would look like:
name number preference1 preference2 preference3
me 123 preference1
me 123 preference2
you 246 preference2
you 246 preference3
other 789 preference2