From excel find rows with same substring in a column -

i need find rows common substring in column.

say, if have 1 row has data (i used : distinguish column)

row1 : ab : abc, bcd, acd row2 : bc : acd, def row3 : cd : abc, dbc row4 : de : bcd, def

so want query / script can show me:

abc in:

row1 row3

bcd in:

row1 row4

acd in:

row1 row2

with layout shown, put

=iferror(find(d$1,$c2)>0,"")

in d2 , copy across , down.

Dil