June 20, 2018 at 7:51 pm
#584

Keymaster
Hello Traci,
Excellent question, with what I hope you will find to be an excellent answer!
In the first screen capture on the left you see typical survey data with Smart Phone? coded with 1, 2, or blank. On the right you see the result of dragging that attribute all the way to the left to form a group for each value as shown on the right.
Fortunately, those values are editable! So, in the second screen capture on the left, you see the result of editing the 1’s to no and the 2’s to yes. Then, dragging the attribute back to the right flattens out the table again.
No formulas required! I hope this makes sense.
Bill
p.s. I think replacing the numbers with meaningful words is an excellent idea, no matter the age of the user.