I must compile over 60 multipage paper surveys. The 1st question has 20 possible responses and the users marked all that applied. The easiest method I can come up with is to "x" the appropriate box and excel replace the "x" with the column title. But I can't get it to work. Can you suggest a formula? or another method?
Thank you!
<tbody>
</tbody>
<colgroup><col><col span="7"></colgroup><tbody>
</tbody>
Thank you!
dog | cat | bird | fish | snake | |
Survey 1 | dog | cat | fish | ||
Survey 2 | cat | bird | snake | ||
Survey 3 | x | x | x | ||
<tbody>
</tbody>
<colgroup><col><col span="7"></colgroup><tbody>
</tbody>