Forum Discussion
Walter8544
Mar 23, 2024Copper Contributor
COLUMNS
I have one column with 80 lines of data that I want to change into multiple column headings. Eg, line 2 of data moves to a column heading next to datum on line one, line 3 to a column heading next to datum that was on line 2, etc.
- PeterBartholomew1Silver Contributor
Calling the existing column 'oneColumn', the formula
= WRAPROWS(oneColumn, 5)
returns 5 columns of 20 items.