New answers tagged concatenate
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&...
- 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, ...
- 6,488
Top 50 recent answers are included