In Column C use:
=UNIQUE(TRANSPOSE(TEXTSPLIT(TEXTJOIN(",",TRUE,B2:B6),",")))
And in Column D:
=COUNTIF(B:B,"*"&C2&"*")