Multiple selection answers each seperated by column, how to isolate one answer?
Hello! I have a dataset with columns Q2_1 to Q2_7, each representing different demographic categories. Each row corresponds to a participant's selection of answers. For example, Q2_1 might represent White/Caucasian, Q2_2 might represent Black or African American, and so on. I need to create a new column that indicates if a specific demographic (e.g., White) was selected but another demographic (e....