you’re free to override this behavior by providing a custom value for thepad_withargument.
Whenwrap_counthas been reached, WRAPROWS starts a new row.
Wrap count
Wrap_countrepresents the maximum number of values in each row.
Once the count has been reached, WRAPROWS starts a new row.
In the screen below, you’re free to see how this works.
you could override this behavior by providing a custom value for thepad_withargument.
The formula in D3 shows default behavior.
As a result, the last 2 cells return #N/A.
To override this behavior, provide a value forpad_with.
By default, TOROW will scan values by row, but TOROW can also scan values by column.
TOCOL Function
The Excel TOCOL function transforms an array into a single column.
By default, TOCOL will scan values by row, but TOCOL can also scan values by column.
