Home > Blockchain >  SPLIT EACH WORD IN NEW ROW
SPLIT EACH WORD IN NEW ROW

Time:01-21

I used this formula to split each word in diffirent row:

=ARRAYFORMULA(TRIM(QUERY(SPLIT(FLATTEN(
 IF(Sheet1!A2:B6000="",,Sheet1!A2:A6000&"×"&SPLIT(Sheet1!B2:B6000, " "))), "×"), 
 )))

but it is working only for the firs tow word in each cell in column A How i can update this formula to split all words?

Here is the sheet sample: enter image description here

  • Related