Home > OS >  Google Sheets duplicating rows by splitting comma separated multiple values
Google Sheets duplicating rows by splitting comma separated multiple values

Time:03-08

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.

I would appreciate your help.

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)})

enter image description here

  • Related