How to split only one column to multiple rows while copying rest of the columns along the way

Question

I have an excel file with numerous rows, and one column contains numerous values that are separated by commas.

Model	Vendor	Serial Number
S20	ABC	1122334455, 5544332211
S21	XYZ	9988776655, 5566778899, 2244668800

The third column should be divided into rows, which I was able to do with ease. However, I also want to copy columns 1 and 2. Thus, it should seem as follows:

Model	Vendor	Serial Number
S20	ABC	1122334455
S20	ABC	5544332211
S21	XYZ	9988776655
S21	XYZ	5566778899
S21	XYZ	2244668800

I manually duplicated the remaining columns into the newly constructed one after first delimiting the column. It takes a very long time because there are thousands of records.

Answer 1

Try this:

=DROP(REDUCE(0,REDUCE(0,C2:C3,LAMBDA(a,x,VSTACK(a,CONCAT(CHOOSEROWS(A2:B3,ROW(x)-1)&"|")&TEXTSPLIT(x,,",")))),LAMBDA(p,q,VSTACK(p,TEXTSPLIT(q,"|")))),2)