Append Search value in next column

[i_LKarthick]

Hi,

I have Table 1,which contain Search value in Column A,

Table1:

Id	Search Value	to be appended
1	ABC	append_1
2	123,ABC	append_2
3	ABC,123,ABC,345	append_3

Table2:

Search Key

ABC

123

Search Key(Partial match also considered) in Table1. if Search key found then append Table1 with Table2 with Search Key.  Id Search Value to be appended Search Key 1 ABC append_1 ABC 2 123,ABC append_2 ABC 2 123,ABC append_2 123,ABC 3 ABC,123,ABC,345 append_3 ABC 3 ABC,123,ABC,345 append_3 123 3 ABC,123,ABC,345 append_3 ABC,123,ABC,345

[binuacs · Accepted solution]

@i_LKarthick One way of doing this

•