How would you present or clean this data in PBI or SQL?

I have a column coming in from a SQL table, which I believe originates from a check box. So the end user selects one or many options, which are then filed into a single data column (with no delimters or anything to split).

We have thousands of records, but this is a distinct selection of the results (key words have been changed as they were quite business specific):

NULL
Advice
AdviceAssess
AdviceAssessPsychological
AdviceLeave
AdvicePsychological
AdvicePsychologicalSocial
AdvicePsychologicalSocialSpiritual
AdviceSocial
Assess
Class
ClassAdvice
ClassPsychological
Control
ControlAdvice
ControlAdviceAssess
ControlAdviceAssessPsychological
ControlAdviceAssessPsychologicalSocial
ControlAdviceAssessPsychologicalSocialSpiritual
ControlAdviceAssessPsychologicalSpiritual
ControlAdviceAssessSocialSpiritual
ControlAdviceLeave
ControlAdviceLeaveAssessPsychologicalSocialSpiritual
ControlAdviceLeavePsychologicalSocialSpiritual
ControlAdvicePsychological
ControlAdvicePsychologicalOther
ControlAdvicePsychologicalSocial
ControlAdvicePsychologicalSocialSpiritual
ControlAdvicePsychologicalSpiritual
ControlAdviceSocial
ControlAdviceSocialSpiritual
ControlAssess
ControlAssessPsychological
ControlAssessPsychologicalSocial
ControlAssessPsychologicalSocialSpiritual
ControlAssessPsychologicalSpiritual
ControlClass
ControlClassAdvice
ControlClassAdviceAssessPsychologicalSocialSpiritual
ControlClassAdviceLeave
ControlClassAdviceLeaveAssess
ControlClassAdviceLeaveAssessPsychologicalSocial
ControlClassAdviceLeaveAssessPsychologicalSocialSpiritual
ControlClassAdvicePsychologicalSocialSpiritual
ControlClassAssess
ControlClassAssessPsychological
ControlClassAssessPsychologicalSocialSpiritual
ControlClassAssessPsychologicalSpiritual
ControlClassLeaveAssessPsychologicalSocialSpiritual
ControlClassLeavePsychologicalSocialSpiritual
ControlClassPsychological
ControlClassPsychologicalSocialSpiritual
ControlClassPsychologicalSpiritualOther
ControlClassSocialSpiritual
ControlClassSpiritual
ControlLeave
ControlLeavePsychological
ControlOther
ControlPsychological
ControlPsychologicalSocial
ControlPsychologicalSocialSpiritual
ControlPsychologicalSpiritual
ControlSocial
ControlSocialSpiritual
ControlSpiritual
Leave
Not specified
Other
Psychological
PsychologicalNot specified
PsychologicalSocial
PsychologicalSocialNot specified
Social

Any suggestions on how to present/handle this column would be useful. I have access to the base SQL table so I can adjust this in there, or handle in PowerBI also.

Thanks