I have imported my data from a qualtrics survey and have some questions responses that are text responses. I am trying to clean up my data and have two questions. I have a response where participants provided text responses to clarify a previous response about education attainment. They have listed a number of variables eg Diploma of Midwifery, Diploma of Education
etc Can I clean this up and convert to a numerical variable - I presume yes, and this will be easy if each participant only lists one form of education. What or how do I handle it if one participant has listed several types of education ? Can nursing, midwifery, child health, educaion etc can I in the variable view, give each course of education a numerical number and then have more than one numerical value? If yes, do I enter these with a comma between them eg
and then for a single participant had all of these qualifications enter them for that single participant as 1,2,3,4, ??
Is there another way to deal with this?