Consolidate Non-numeric data
I have a set of data from a large survey that requires multiple people to
fill out for it to be complete. When I export the data to Excel, it looks
like this:
Reply 1 Reply 2 Reply 3
Do you use a car? Y
Do you like red? Y
Do you eat fruit? Y
Do you like green? N
Do you like purple? Y
Do you like blue? N
Do you like white? Y
I would like to produce the following output (effectively placing a copy of
all the replies in one column for easier reference so I don't have to look
for the columns with the answers)
Answer Reply 1 Reply 2 Reply 3
Do you use a car? Y Y
Do you like red? Y Y
Do you eat fruit? Y Y
Do you like green? N N
Do you like purple? Y Y
Do you like blue? N N
Do you like white? Y Y
Does anyone have any thoughts, suggestions, or know how to do this? Thank
you for your help.
|