How to join this type of data?

I have several columns representing different categories. Each category have multiple selection. I need to show in one cell all the name of the categories that are not blank.

I don't know what formula to use or if I need to create reference table first.

Best Answers