Hi
I have a report from survey software which produces multiple columns for a reply to a radio button where one is asked to pick all choices that apply

Example:-
Ethnicity
column heading & contents
ethnicity_1; 0
ethnicity_2; 1
ethnicity_3; 0
ethnicity_4; 1
ethnicity_5; 0

Here, the subject has chosen the 2nd and 4th choices of ethnicity

I am thinking of creating a VBA subroutine which replaces the above 5 columns with a new column
column heading and contents
ethnicity; 2, 4

Question: Does this approach seem reasonable or are there better suggestions?

If you wish to throw some VBA code at me - please feel free
Bob M