이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
TOROW(array, [ignore], [scan_by_column])The TOROW function transforms an array or range into a single row. It provides options to ignore specific types of values, such as blanks or errors, and allows you to control the scanning order.
=TOROW(A1:B2)결과: {1, 2, 3, 4}
Converts a 2x2 range into a single row.
Yes, by setting the ignore argument to 1 or 3, you can exclude blank cells from the result.