Find unique values on all search rows separated by comma

[habrhi]

Hi all,

I need to count the unique values of each row i have in my search (maybe this sounds abstract to you), the data i have in my cells are separated by "," .
Here is an example:

ID               |             A                 |                B
1                 |        a,b,c                |                3                   ("a","b","c" are unique here)
2                 |            a,d               |               1                   ("a" has been already found, so the only unique value is "d")
3                  |          b,k,e            |               2                   ("b" has been already found, only unique values are "k" and "e")

I tried to run dedup and rex field , but cannot get the search right. could anyone help?
One more question , is it possible to duplicate the row but only in each line i find only one value (example):

ID               |             A                       |                A_mod
1               |             a,b,c                |                  a
1               |             a,b,c                |                  b
1               |             a,b,c                |                  c
----------------------------------------
2               |             a,d                    |                  a
2               |             a,d                    |                  d
-----------------------------------------
3               |             b,k,e                 |                  b
3               |             b,k,e                 |                  k
3               |             b,k,e                 |                  e

Sorry if i posted two questions, i am just asking about the possibility and how to achieve it.
I thought of this exemple because it might get easier by then to run dedup

[ITWhisperer]

| eval A_mod=split(A,",")
| mvexpand A_mod
| dedup A_mod
| stats values(A) as A, count as B by id

Full solution

[ITWhisperer · Accepted solution]

Second part is reasonably simple

| eval A_mod=split(A,",")
| mvexpand A_mod