1. Introduction to Excel WRAPCOLS
The WRAPCOLS function allows you to convert a long column of data into a table format. The data is transformed from a one-dimensional array into a two-dimensional table.
2. WRAPCOLS Arguments
This is the syntax for using the
WRAPCOLS function.=WRAPCOLS(vector, wrap_count, [pad_with])vector: required The vector or reference to wrap.wrap_count: required The maximum number of values for each column. In simple terms, it determines how many rows of data to obtain.pad_with: optional If the size of the array is not a multiple of the wrap_count parameter, this parameter is used to fill the extra cells. By default, it is filled with #N/A.3. Getting Started with the WRAPCOLS Function
Type on the keyboard:
=WRAPCOLS(
4. Select the Source Data Range
At this point, the function will prompt you to select the source data range. Click on the start of the source data
B3, then hold down the Shift key and click on the end of the source data B22. This will select the content of the source data and fill it into the function parameters: =WRAPCOLS(B3:B22.
5. Specify How Many Rows of Data to Convert
Here we set the data to be converted into a table with 3 rows of data. The function now is:
=WRAPCOLS(B3:B22, 3)
6. Press the Enter Key
At this point, you will see that the data has been converted into a two-dimensional table with 3 rows.
7. Empty Data Displayed as #N/A
You may notice that some data is displayed as
#N/A, which is because there are no more data to display.8. Use an Empty String to Replace #N/A
We can pass in the third parameter as:
"", then press the Enter key to save.
9. Task Completed
This way, we have converted the data into the format we wanted.
Extension Tip: If
Extension Tip: If
wrap_count is 1, it will convert a column of data into a row of data.10. 🎉 Finish! 🎉
Author's Note: I hope you can feel the effort I put into these tutorials. I hope to create a series of very easy-to-understand Excel tutorials.If it is useful, help me share these tutorials, thank you!
Follow me: