Automatic line wrapping in Google spreadsheets. How to do it?

Question

Google Sheets

There is a table that will be filled in the future. We need a script that will transfer all the values ​​of the desired string (A: Z) to string #3 (A3: Z3). The search is performed by the keyword in cell A2.

Answer 1

1) Look for a value (using SEARCH (), for example), get the line number
2) Transfer values ​​with a formula

=arrayformula(indirect((НОМЕР_СТРОКИ)&":"&(НОМЕР_СТРОКИ)))

, where LINENUM is the number found in 1)