Split the unique values into the column

Question

I want to split (text to column) every row by only the unique values.

I have tried using Flatten but not automatically generate the other rows.

could you give one-apply formula that can generate each row in it? every help is appreciated.

Here is the document:

https://docs.google.com/spreadsheets/d/1OJPswTTw-Bm4OHgtre8nrLG2H35uQeBg0nGHHeV124k/edit?usp=sharing

Thank you...

Answer 1

You may try:

=map(A:A;lambda(Σ;if(Σ="";;unique(split(Σ;",");1))))