This is an example:
I need to split by " , " in a new row and duplicate the others
The desired output on a new sheet:
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityThis 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,","))}