Google Sheets-functie

TOROW

Returns the array as a single row.

Formule genereren met AI Dezelfde functie in Excel

Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.

Syntaxis

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.

Argumenten

arrayvereistThe array or range to return as a row.
ignoreoptioneelDetermines which values to ignore: 0 (keep all), 1 (ignore blanks), 2 (ignore errors), 3 (ignore blanks and errors).
scan_by_columnoptioneelIf TRUE, scans by column; if FALSE (default), scans by row.

Voorbeelden

=TOROW(A1:B2)

Resultaat: {1, 2, 3, 4}

Converts a 2x2 range into a single row.

Veelgestelde vragen

Can TOROW handle empty cells?

Yes, by setting the ignore argument to 1 or 3, you can exclude blank cells from the result.

Gerelateerde functies

TOCOL WRAPROWS WRAPCOLS TRANSPOSE