Forum Discussion
Splitting multiple choice data into separate columns
I have a big data set and one of the columns contains data that was populated from a multiple choice answer on a form where the data came from. The column in question looks something like below. I wa...
Let's say Referrals is in B1 and the headings Acupuncture, Chiropractor etc. in C1, D1, ...
Enter the following formula in C2:
=IF(ISNUMBER(SEARCH(C$1,$B2)),"x","")
Fill to the right, then down (or vice versa).
See attached sample workbook.