This is an example:
I need to split by " , " in a new row and duplicate the others The desired output on a new sheet:
This is an example:
I need to split by " , " in a new row and duplicate the others The desired output on a new sheet:
Here is how you can do it for one row
={transpose(split(rept(A2&",",counta(split(B2,","))),",")),transpose(split(B2,",")),transpose(split(C2,","))}