Mar 23 2024 12:55 PM
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.
Mar 23 2024 01:04 PM
@Walter8544
Calling the existing column 'oneColumn', the formula
= WRAPROWS(oneColumn, 5)
returns 5 columns of 20 items.