Returns the array as a single row.
פונקציה זו פועלת ב-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.