Table of Contents
The WRAPCOLS function in Google Sheets allows users to wrap the contents of a specific range of cells into multiple columns. This function is helpful when working with large amounts of data that need to be organized and presented in a more concise manner. By using the WRAPCOLS function, users can easily adjust the layout of their data and improve readability. This function is particularly useful for creating reports or presentations that require a neat and organized appearance. To use the WRAPCOLS function, simply select the desired range of cells and enter the function along with the desired number of columns to wrap the data into. This feature can greatly enhance the efficiency and professionalism of data management in Google Sheets.
WRAPCOLS function
This function wraps the provided row or column of cells by columns after a specified number of elements to form a new array.
Sample Usage
WRAPCOLS(A1:E1, 2): A WRAPCOLS function that wraps the range with 2 values per column.
WRAPCOLS(A1:E1, 2, “No value”): A WRAPCOLS function that wraps the range with 2 values per column and fills the extra cells with “No value.”
Syntax
WRAPCOLS(range, wrap_count, [pad_with])
range: The range to wrap.wrap_count: The maximum number of cells for each column. If the value isn’t a whole number, it’s rounded down to the nearest whole number.[pad_with]: The value with which to fill the extra cells in the range. By default, the WRAPCOLS function fills the extra cells with #N/A.
Examples
Wrap simple data with WRAPCOLS
Example data:
A | B | C | D | E | |
|---|---|---|---|---|---|
1 | A | B | C | D | E |
Example: Input this formula in G1: =WRAPCOLS(A1:E1, 2)
Result:
G | H | I | |
|---|---|---|---|
1 | A | C | E |
2 | B | D | #N/A |
Make a Copy
Wrap data with “No value” as pad with WRAPCOLS
Example data:
A | B | C | D | E | |
|---|---|---|---|---|---|
1 | A | B | C | D | E |
Example: Input this formula in G1: =WRAPCOLS(A1:E1, 2, "No value")
Result:
G | H | I | |
|---|---|---|---|
1 | A | C | E |
2 | B | D | No value |
Make a Copy
Related functions
- WRAPROWS function: This function wraps the provided row or column of cells by rows after a specified number of elements to form a new array.
Cite this article
stats writer (2024). How can I use the WRAPCOLS function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-wrapcols-function-in-google-sheets/
stats writer. "How can I use the WRAPCOLS function in Google Sheets?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-wrapcols-function-in-google-sheets/.
stats writer. "How can I use the WRAPCOLS function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-wrapcols-function-in-google-sheets/.
stats writer (2024) 'How can I use the WRAPCOLS function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-wrapcols-function-in-google-sheets/.
[1] stats writer, "How can I use the WRAPCOLS function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How can I use the WRAPCOLS function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.