Text to Column - Organize Specific Text to Specific Column

I have a survey that people completed and the download of data is converted into one cell, separated by a comma. The respondent was able to select all that applied, so each answer is different - containing some of the same values, but not all. I want to convert this text to columns, but not simply straight across - I'd like to organize specific answers to specific columns, so that I can identify who all selected "Family/parent contacts."

I attached my excel column by itself, to show what I'm looking for. Any assistance is greatly appreciated!

Use PowerQuery (Get&Transform) and Conditional Columns with "contains" option

An alternative would be to manually type all possible entries across row 1 (in your sample, this would start in B1) then use a formula like this in B2:

=IF(COUNTIF($A2,"*"&B$1&"*"),"X","")

Drag this formula down and across as far as needed.

This will place an X under all applicable methods.