The WRAPCOLS function takes three arguments:vector,wrap_count, andpad_with.
Vector andwrap_countare both required.Vectormust be a one-dimensional array or range.Wrap_countis a number that represents the length of each column.
you’re able to override this behavior by providing a custom value for thepad_withargument.
Whenwrap_counthas been reached, WRAPCOLS starts a new column.
Wrap count
Wrap_countrepresents the maximum number of values in each column.
Once the count has been reached, WRAPCOLS starts a new column.
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.
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.
