Google Sheets duplicating rows by splitting comma separated multiple values
10:07 07 Mar 2022

I have Data in Google Sheets Where multiple Dates are mentioned in single column. I want to separate the Each date and same row should be repeated for each date.

Trying with this but its not working.

=ARRAYFORMULA({"DATE","EMPLOYEE NAME";QUERY(IFERROR(SPLIT(FLATTEN(IFERROR(Sheet1!A:D
&CHAR(9999)&SPLIT(Sheet1!H:H,","),)),CHAR(9999)),),
"SELECT Col2, Col1 WHERE Col2 IS NOT NULL ORDER BY Col2 ASC",0)})

Sheet Link

I tried with this but its not spliting the dates.

function result(range) {
  delimiter = ","
  targetColumn = 8

  var output2 = [];
  for(var i=0, iLen=range.length; i
google-sheets google-sheets-formula flatten cartesian-product textjoin