I conducted a survey study where people were asked to select all that apply. The options included "less than normal", "about the same as normal", and "more than normal" for two different questions. The data export coded this question as 6 binary scale variables instead of combining into two ordinal variables. Is there a way I can combine these into an ordinal variable for each of these question portions? I could copy and paste into Excel and calculate the new values by hand (e.g. 1-0-0--> 1; 0-1-0 -->2; 0-0-1 --> 3), but I don't want to introduce human error.