0

This is an example:

enter image description here I need to split by " , " in a new row and duplicate the others The desired output on a new sheet:

enter image description here

1
0

Here is how you can do it for one row

={transpose(split(rept(A2&",",counta(split(B2,","))),",")),transpose(split(B2,",")),transpose(split(C2,","))}

Not the answer you're looking for? Browse other questions tagged or ask your own question.