New answers tagged

0 votes

How can I use ARRAYFORMULA (or something similar) with GOOGLETRANSLATE?

After analysis, I found kind of compact solution. a1:a, "en", "ko" are options it doesn't need ARRAYFORMULA: =TransPose(Split(GoogleTranslate(Join(". ",A1:A), "en&...
user avatar
  • 1
0 votes

Splitting hierarchical codes into parent items (Google Sheets)

Try split() and join(), like this: =arrayformula( join( ", ", unique( flatten( transpose( left( split(A2, ", ", true, true), sequence( max( len( split(A2, ", ", true, ...
user avatar
  • 6,488

Top 50 recent answers are included