I have to enter results from a survey into an excel database. There is a coding system that I have to go by. A couple of participants in the survey entered more than one answer for certain questions but the cell formatting only allows for one value to be entered in the cell therefore the second answer is lost. How can i accomodate for this without losing data and destroying the function and purpose of the survey?
I really would appreciate any help that you could give me.